Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Count the number of cells with numbers in specified range
Syntax of Excel COUNT formula:
=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.