Countifs + Distinct + Contains

Lisa B 2022 · 12/06/24

Looking for some help folks if anyone has any ideas

I have a grid of marketing content by market, some of which are the same content in different languages.

I want to count the content types by market but only unique content, i.e. I dont want to count the same piece of content in all languages.

I've tried this - =COUNTIF(DISTINCT({Range 6}), CONTAINS([Primary Column]@row, {Range 5})) but i get zero across the board.

Anyone had this before?

Leibel S · 12/06/24

Try this:

=COUNT(DISTINCT(COLLECT({Range 6},{Range 5},CONTAINS([Primary Column]@row, @cell))))

Leibel S · 12/06/24

Try this:

=COUNT(DISTINCT(COLLECT({Range 6},{Range 5},CONTAINS([Primary Column]@row, @cell))))

Lisa B 2022 · 12/10/24

@Leibel S You've saved the day!!! Thank you so much!

Best Answer