Keep Track With Excel Count Functions

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.

countempty

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.

_______

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.