K
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!
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!