COUNT
Count the number of cells with numbers in specified range
Count the number of cells with numbers in specified range
Syntax of Excel COUNT formula:
=COUNT(value1,[value2],…)
In words:
=Count the number of cells with numbers in(this range of cells, [this range of cells], and any other range specified… )
Consider the following data:
Putting this formula:
=COUNT(A1:B9) gives 6 as only six cells contain numbers.