Count If combination of two values occurs multiple times


Hello community,

I'm trying to count if or flag when a value repeats in two columns.

As you can see below I have the formula for one column but I want to count if both Location and Count Cells Duplicate.

In this instance I can see that a combination of 'London (location) 3 (count)' occurs twice...

What is the formula for this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!