Using cell B51=COUNTIF(B20:B50,">0")
COUNTIF counts the number of cells, (not their contents), that meet the set criteria, in this case if the contents are greater than 0.
Mark
Hi
I have numbers in cells b20:b50. The numbers are positive numbers ranging from 0 to infinity.
What I would like to do is count how many of the numbers are greater than 0.
I thought it might be a combiation of the IF and COUNT functions, but can't seem to get the formula to work.
Thanks for any help.
Jim

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic