Excel has several different methods of counting depending on what it is you want to count. This week, with my sincerest apologies to Elizabeth Barrett Browning, we’ll take a look at those options and show you how to get the results you want.
Understanding the various counting functions in Excel can be a little bit confusing at first. Have no fear, with a little guidance you’ll have it mastered in no time. So fasten your seat belt and enjoy the ride!
Counting How Many Cells Contain Numbers
Counting How Many Cells Are NOT Blank
Counting How Many Cells Meet A Specified Criteria
Counting How Many Cells Are Blank
Quick & Dirty, No Formula Required Method
The animation below shows how you can use the status bar to get an automatic count with out any formulas at all. Just right click and select Count or Count Nums and the status bar will count the range that is selected in your worksheet.
Before you get away for the weekend, I just want to say a great big Thank You! to everyone who took the time to weigh-in on what type of tips you’d like to see here. You can check on the results here if you’re curious and I’ll try to start mixing in some new things based on your feedback in the next few weeks.