Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
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?? |
#3
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIF problem | Excel Discussion (Misc queries) | |||
Countif Problem | Excel Discussion (Misc queries) | |||
COUNTIF and automatic type conversion problem | Excel Discussion (Misc queries) | |||
COUNTIF and automatic type conversion problem | Excel Worksheet Functions | |||
countif problem | Excel Discussion (Misc queries) |