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