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

Hi Phil,

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

WKr,

JP

wrote in message
...
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

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.

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.

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

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


" wrote:

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