How do you stop blanks being counted as zero's

J

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
 
P

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?
|
|
| ---
|
|
 
Top