COUNTIF

[Kathy McG]

I have several thousand lines of information that I am
breaking down into subgroups. I am then trying to create
a countif statement to sum how many cells in each column
are showing any number above 0. I do not want to include
null cells. I keep getting an error message stating there
is an error in the formula. (I don't want to sum the
numbers, I want to count the cells). I have tried the
following formulas but none of them work:

= Countif(AB252:AB371,<>0),count as 1
=IF(ab252:ab371,0) count as 1

Any other ideas?

Thank you!

 

[Peo Sjoblom]

=COUNTIF(AB252:AB371,">0")