Maybe =COUNTA(U1:U8)

Regards,
Stefi

€žK****ij€� ezt Ã*rta:

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