Advice on a formula

[datadummy]

I am using the following formula =COUNTIF(Sheet1!F:F,"*MEDICAL CENTER : PROPERTY : BHU") this is returning an incorrect count and I can't figure out why, there are only 9 events and my formula is returning 148. The portion in parenthesis is copied and pasted from the raw data to assure I captured it exactly as it is entered. Any suggestions on a better more precise formula?

 

[awoohaw]

can you post a mini worksheet with the xl2bb add in? (Link is below.)

Please give more information to help the forum help you. There could be any number of reasons. but we can't guess what data you have in the 148 + cells.

 

[Skyybot]

I think that it may be the * in the formula. That usually represents a wildcard.

 

[datadummy]

can you post a mini worksheet with the xl2bb add in? (Link is below.)

Please give more information to help the forum help you. There could be any number of reasons. but we can't guess what data you have in the 148 + cells.

I've tried uploading via the link in the past and due to being on a work computer I am unable to.

 

[awoohaw]

And to add onto what @Skybot says... if you are not using the asterisk for a wildcard but truly an asterisk. then precede that with a tilde.

 

[awoohaw]

try:

COUNTIF(Sheet1!F:F,"~*MEDICAL CENTER : PROPERTY : BHU")

 

[datadummy]

I think that it may be the * in the formula. That usually represents a wildcard.

I removed the * and I am still getting the same results. I have checked all the filters to assure I'm not missing any with the term and I verified they're only 9 such events yet I am still getting a count of 148.

 

[awoohaw]

can you paste 30 or so of the values in a table here? the icon above the chat window after the double quote will format a table for you.

 

[datadummy]

try:

COUNTIF(Sheet1!F:F,"~*MEDICAL CENTER : PROPERTY : BHU")

I tried adding the tilde and it returned 0.

 

[awoohaw]