View Single Post
  #1   Report Post  
psion
 
Posts: n/a
Default 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??