Dec 30 2020 07:07 AM
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.
Dec 30 2020 07:17 AM
@Purplepacman That may be as simple as:
=COUNT(range)
where range is the range of cells you want to test.
Dec 30 2020 07:17 AM
The COUNT function returns the number of cells with a numeric value, so you can use a formula such as
=COUNT(A1:A150)
Dec 30 2020 08:14 AM
Super easy! Thank you @Riny_van_Eekelen
Dec 30 2020 08:15 AM
Super easy! Thank you @Hans Vogelaar