Excel COUNT and COUNTA Functions

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.

Examples:

Counting of multiple cells containing numbers within a range:

=COUNT(Range of cells)
A
1.6
28
3ExcelBee
47
52.00
670%
7#DIV/0!
81
97/23/2013
101
11=COUNT(A1:A10)

Result: 8

Extra Tips:

  • COUNT function counts real numeric values like in-putted numbers, dates, percentage etc.
  • Any formula returning numeric value will be counted in COUNT function until it does not give any error.
  • If you see number in cells but not being counted, you should try Text to Column once to change cells formatting to numbers.
  • Do not get confused with COUNT function and the count of value shown at bottom while you have selected a range of cells. Count at the bottom will give you value as COUNTA function only.

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
16
2
3ExcelBee
47
50
69
7#DIV/0!
81
97/23/2013
101
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.

Was this article helpful?
YesNo