countif problem.
 

I wrote a formula in a cell that contains the following:

=countif(f5:f268," char(32)") / countif(e5:e268," char(32)")

I have verified that any unused cells have blanks spaces in them.

Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.

Any suggestions??

Not sure I get it, but try

=countif(f5:f268,""&char(32)) / countif(e5:e268,""&char(32))

"psion" wrote in message
...
I wrote a formula in a cell that contains the following:

=countif(f5:f268," char(32)") / countif(e5:e268," char(32)")

I have verified that any unused cells have blanks spaces in them.

Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.

Any suggestions??

OK... Ive fixed the problem(but Im still unsure why it is happening).
What I did to fix the problem is re-enter any cell that contain only
numerical data. Alphanumeric was ok...

Bob Phillips wrote:
Not sure I get it, but try

=countif(f5:f268,""&char(32)) / countif(e5:e268,""&char(32))

"psion" wrote in message
...

I wrote a formula in a cell that contains the following:

=countif(f5:f268," char(32)") / countif(e5:e268," char(32)")

I have verified that any unused cells have blanks spaces in them.

Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.

Any suggestions??