Are you looking for a way to quickly count the number of items in a cell range? Then this video might be for you. In under 10 minutes, learn how to write excel COUNT and excel COUNTA formulas, understand the difference of COUNT vs COUNTA function in Excel, and which one best suits your needs.
In this tutorial, we will also teach you about Absolute and Relative Referencing so you can drag and fill your formulas while keeping cell references locked. This is a very helpful tool that you will use a lot in your spreadsheets.
To see the latest Excel training courses from Simon Sez IT, go here:️
https://www.simonsezit.com/course-category/excel/
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Macros, VBA and Advanced Formulas in Excel Tutorials here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hCdjRhXaY7Btz1z0FVUaZI
How to Create a Dashboard in Excel https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz
Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)