How do you stop blanks being counted as zero's

[judoist]

I have a database with two columns of single figures. I've been usin
the IF function to identify whether a cell contains a zero. If Yes 1 i
returned, if No 0.

For some reason Excel 2000 seems to count the blank cells as zero's!
Have i set up my page wrongly or is there some other reason?

Anyone

 

[Piers 2k]

Not sure why it's doing what it's doing. Count will only count numbers,
CountA will count numbers and text, but both ignore blanks. Try using a
CountIF function instead

e.g. =COUNTIF(A1:A10,0)

This will count the Zero's in a range. Maybe change the 0 to <>0 to count
the cells that don't have a zero.

Will this solve your problem?

Piers.


| I have a database with two columns of single figures. I've been using
| the IF function to identify whether a cell contains a zero. If Yes 1 is
| returned, if No 0.
|
| For some reason Excel 2000 seems to count the blank cells as zero's!?
| Have i set up my page wrongly or is there some other reason?
|
| Anyone?
|
|
| ---
| Message posted
|

 

[Andy B]

Hi

Have a look at the COUNTA formula - which doesn't count blanks.

 

[judoist]

Thanks guys!

Natha