Counting if with multiple criteria

[a1b2c3d4e5f6g7]

Is their a easier method/different method to write this formula? It's about counting if with multiple criteria.

Please Login or Register  to view this content.

Thnx

[Sam Capricci]

Countifs works with multiple conditions, have you tried to adjust it using that?

[a1b2c3d4e5f6g7]

The formula works, but if i have to adjust the C's. It's just a lot of work. So i hope there maybe was an easier way to write the formula.

[Sam Capricci]

I'm not following what you mean by having to adjust the C's. But I tested your formula with dummy data and found that this part of it can be replaced with this...
=MIN(COUNTIF(A2:B2,B16),COUNTIF(A2:B2,C16))
=MIN(COUNTIFS(A2:B2,B16,A3:B3,C16))
so you might be able to continue it on as =MIN(COUNTIFS(A2:B2,B16,A3:B3,C16,A4:B4,B16,A5:B5,C16)) etc. adding the $ to the parts of the formula you want to lock in.

EDIT: BTW, my version uses , you would need to substitue ; for it to work for you.