How do you stop blanks being counted as zero's

  • Thread starter Thread starter judoist
  • Start date Start date
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
 
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
|
 
Back
Top