Excel COUNT Function

Excel COUNT function counts the cells which has numeric values. For instance if we want count total cells that has only and only numeric values within a range, then Excel COUNT function will return you the desired result. COUNT function will ignore blanks cells and cells containing text value and errors.

Syntax And Examples:

Counting of multiple cells containing numbers within a range:

=COUNT(Range of cells)

A
1 .6
2 8
3 ExcelBee
4 7
5 2.00
6 70%
7 #DIV/0!
8 1
9 7/23/2013
10 1
11 =COUNT(A1:A10)

 

Result: 8

Extra Tips:

Excel COUNTA Function

Excel COUNTA Functions counts each and every cells within the selected range that is non-blank.

Syntax And Examples:

Counting of multiple cells containing any value within a range:

=COUNTA(Range of cells)

A
1 6
2
3 ExcelBee
4 7
5 0
6 9
7 #DIV/0!
8 1
9 7/23/2013
10 1
11 =COUNTA(A1:A10)

 

Result: 9

COUNTA function counts all non-blank cells. Cell with error will be also included in the count by COUNTA function. You can also use CTRL + A short-cut key in excel sheet to get count of total non-blank cells in a range.