Need help with determining a correct formula!

Copper Contributor

I have close to 150 cells that may contain a number. I would like to create a formula that counts all of the cells that contain a number. In simplistic terms, if 12 of the 150 cells have some sort of #, I would like the formula to calculate the # 12. Can anyone give me some advice as to how to accomplish this? Thanks in advance.

4 Replies

@Purplepacman That may be as simple as:

 

=COUNT(range)

where range is the range of cells you want to test. 

@Purplepacman 

The COUNT function returns the number of cells with a numeric value, so you can use a formula such as

 

=COUNT(A1:A150)

Super easy! Thank you @Riny_van_Eekelen 

Super easy! Thank you @Hans Vogelaar