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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


" wrote:

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.