Excel COUNT Function

What does Excel COUNT Function do?

Excel COUNT function is used to count how many “number” in the specified range. Note that “number” in text format (with the green triangle on the top left) is not counted.

It can be used to count non-empty cells in a column that contains number.

You can also read the below article that explains COUNTA Function, which counts non-empty values regardless of numeric or text.

Excel worksheet COUNTA Function

Syntax of Excel COUNT Function

=COUNT(value1, value2, value3...)

where value can be a range contains multiple cells, or simply a single value. COUNT function accepts 30 parameters (arguments) at most.

Example

In column A of the below table, it contains number, text and “number in text format” (in green triangle).

excel_function_count

Note that “number in text format” (A2) does not count, empty cells (A9:A10) do not count, letters (A3, A4, A7) do not count.

Example Formula Result Explanation
1 =COUNT(A1:A10) 3 There are 3 numbers in the range
2 =COUNT(A1:A10,”a”,5) 4 Count in example 1 plus number “4”

Outbound References

https://support.office.com/en-za/article/COUNT-function-47858132-8828-4041-8c5b-a5fb729bab6f

 http://www.techonthenet.com/excel/formulas/count.php

http://spreadsheets.about.com/od/excel2010functions/qt/2010-04-01-excel-2010-count-function.htm

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist
- Microsoft Specialist
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *