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?