How to count zeros and not blank in selected range?
Try
=COUNTIF(A1:A10,0)
Mike
"K****ij" wrote:
Hi
Well I have some data in which i wish to count number of "0" in the selected
column or row. I tried out some simple 'If' formula as "=IF(U8=0,1,0)" but it
does not work when the cell is blank. It displays 1, I was going to use the
sum function to make total of one.
Also This formula works only for one cell and not for the range(column or
Row), can u help me out for the range.
Thanks
|