countif not finding all the required data

[philhuntley]

Hi,

My countif statement is not locating all the specific data I'm asking
it to locate. For example, I'm asking it to count the number of cells
with the specific value "FF2" typed into them but when I double
checked the value it was 1 short.

Any ideas where I am going wrong?

Help will be greatly appreciated.

Thanks, Phil

 

[JP Ronse]

Hi Phil,

Probably there is 1 cell containing an extra space "FF2 ". Use edit/replace
to check on this.

WKr,

JP

 

[Luke M]

Is the range in your formula large enough (encompasses all your data)?
Does one of the cells actually contain "FF2 " (note the space)?

 

[philhuntley]

Hi, thanks for your replies.

I tried "ctrl+f" to find all "FF2"'s and it fuond 12. My formula only
found 10 and then there is 1 in the table heading and the left over
one is in my data field which I have highlighted with all my other
data.

Argh this is so annoying!

Thanks guys.

 

[Luke M]

Ctrl+F is able to search within cells, thus counting "FF2 ". COUNTIF looks at
entire cell. If there's no similar data, you might try a find&replace of:
Find: *FF2*
Replace: FF2