Sunday, April 10, 2011

Count values with the COUNT function (video)

The process of manually counting values in Excel is time-consuming and error-prone, particularly when you have a lot of data. Fortunately, there are some automated ways to count values. From the questions we receive from our customers on the count, it is 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, simply select the range of cells containing these values and then 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 count value in the row.

Value count using a Total row in a table

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

COUNT function

Therefore, the function returns the number of values and displays them in a worksheet. How easy is that?

To see it in action, watch this video.

For more information about this function, and in other ways that you can count in Excel, see COUNT function and ways to count the values in a worksheet.

Don't let the fact that the Earl are an intimidating-it is really easy to use, and once you know it, you will 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 know more about how people use this feature.

-Frederique Klitgaard

View the original article here

No comments: