Keep Track With Excel Count Functions

Lots of people visit the 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

There are a few quirks with the Count functions though, 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.