Forum Discussion
Solved
COUNTIF formula to exclusively count when all criterias are listed.
Hi there. I've been trying to create a formula where it counts the amount of times a row contains ALL the criteria i have set out, and not just count when at least 1 of the criteria is counted. ...
MontyKnoll Try this:
=SUM(COUNTIFS(C2:C26,"Group",B2:B26,{"Cold","Room Temp"}))
or use a pivot table.
MontyKnoll Try this:
=SUM(COUNTIFS(C2:C26,"Group",B2:B26,{"Cold","Room Temp"}))
or use a pivot table.
It works! I knew there had to be a way. Thank you