Basic Microsoft Excel Functions: COUNT

The COUNT function counts the number of cells in a range that contain a number

COUNT is very simple formula that can be used to create much more powerful formulas. If a cell in your selected range has a number in it, Excel will class that as ‘1’ and then total up all the 1’s to produce the answer.

Syntax

The syntax for the COUNT formula is:

=COUNT(range)

You can add up to 255 ranges into your statement by separating each one with a comma e.g

=COUNT(range1, range2, range3) etc…

Although if you were ever in a situation where 255 ranges needed to be counted it might be an idea to investigate other options to help you

Example

In the below screenshot the formula is set to COUNT the cells in the range A1:A12 that have numbers in them

Click on the image to expand it
Click on the image to expand it

The result is 10

Click on the image to expand it
Click on the image to expand it

 

COUNT can prove to be a very useful formula when combined with an IF statement (discussed here). Suppose that you have two ranges of data but the criteria for counting the values in each range is different. You can combine IF and COUNT to produce:

Click on the image to expand it
Click on the image to expand it

 

What is this formula doing?

IF the value of cell B2 is less than 5, COUNT the number of values in range A5:A14, otherwise COUNT the number of values in range B5:B14

Can you think of any examples where COUNT can be useful?

If you’ve found this article interesting and or useful please share it on social media using the handy share buttons

Subscribe to our mailing list to be the first to know when new articles are published

At Happy Duck we build bespoke business and financial management tools for small, medium and large companies that help them achieve their goals. This makes us happy. Find out more about us and about our services.

More in Excel Basics

0 Comments

Leave a comment

Your e-mail address will not be published. Required fields are marked *