How do I create a formula to count a key phrase in a sheet?

RachelSylvia

I'm looking to have a count of how many times a person's name is referenced in a sheet I created. I am trying to create a formula that will recognize the name even when there are other names included in the cell.

I am referencing ANOTHER sheet in my formula which is where the trouble has started for me…

Ex.

=COUNTIF([{Ops Bullets Tracker Range 2}]:[{Ops Bullets Tracker Range 2}], CONTAINS("Eric Wagner", @cell))

and I keep getting the #UNPARSABLE error

Nic Larsen

The structure of your formula is off a bit:

Try:

=COUNTIF({Ops Bullets Tracker Range 2}, CONTAINS("Eric Wagner", @cell))

RachelSylvia

Thank you SO much - that worked. I really appreciate your help!

Nic Larsen

The structure of your formula is off a bit:

Try:

=COUNTIF({Ops Bullets Tracker Range 2}, CONTAINS("Eric Wagner", @cell))

RachelSylvia

Thank you SO much - that worked. I really appreciate your help!