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.
The syntax for the COUNT formula is:
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
In the below screenshot the formula is set to COUNT the cells in the range A1:A12 that have numbers in them
The result is 10
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:
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?