Within a SUMIFS formular, I'm trying to add on to a count if a contact appears in a multi-contact or

Andy Trickett

Paul Newcome

You would use a HAS function for the criteria like so:

HAS(@cell, [Primary Column]@row)

Paul Newcome

You would use a HAS function for the criteria like so:

HAS(@cell, [Primary Column]@row)

Andy Trickett

Genius, thanks @Paul Newcome I was almost there, just didn't figure out the (@cell, part! many thanks

Paul Newcome

Happy to help. 👍️