Back
Excel

Count your values with the COUNT function (video)

The process of manually counting values in Excel is time-consuming and error-prone, especially when you have a lot of data. Fortunately, there are a few automated ways to count values. From the questions we get from our customers about counting, it’s clear that not everyone knows how to go about it. There are different methods, depending on what you want to count.

For a simple value count, I just select the range of cells that contains those values, and then I look in the status bar.

Status bar showing a value count

Or, if my data is in an Excel table format, I can quickly get a value count in the Total row.

Value count using a Total row in a table

But to keep track of a value count on the worksheet, I use the COUNT function, which counts the number of cells that contain values, and then specify one or more ranges that contain the values within the parentheses.

COUNT function

The function then returns the number of values and displays it in the worksheet. How easy is that?

To see it in action, check out this video.

To learn more about this function and other ways you can count in Excel, see COUNT function and Ways to count values in a worksheet.

Don’t let the fact that COUNT is a function intimidate you-it’s really simple to use, and once you know it, you’ll never go back to counting by hand. If you already know about the COUNT function and use it on a regular basis, do you have any tips to share? We’d love to hear more about how people are using this function.

–Frederique Klitgaard