Lots of people visit my Contextures website looking for information on the Excel Count functions.
Counting seems like an easy thing to do in Excel, if you’ve been using the program for a while. But, if you’re just starting out, it might not be so obvious.
Count Quirks
Even if you’re an experienced Excel user, there are a few quirks with the Count functions, that you might not have noticed yet.
For example, different count functions treat “empty” cells differently, as you can see in the screenshot below.
- In Row 5, the blue cells contain a formula that creates an empty string.
- The COUNTA function counts that cell, even though it looks empty.
- The COUNTBLANK function counts the cell too, even though it contains a formula.
Watch the Video
To see the Excel Count functions that count numbers only, any data, or blank cells, you can watch this short video.
More Excel Count Function Examples
There are many more tips, examples and videos on the Excel Count functions page on my Contextures site.
Video: 7 Ways to Count in Excel
To see a quick overview of 7 ways to get a total count of cells in Excel, watch this 77-second video. There are written steps for each count function on the Excel Count functions page.
_______