I’m trying to write a formula that will count up the number of instances a set of criteria are met in an array of cells
So far I have been using the SUMPRODUCT() function but it doesn’t allow me to use multiple criteria for matching. For example,
But what I really want is something like,
=SUMPRODUCT(A1:A100=“MATCH1”,B1:B100=“MATCH2a” || “MATCH2b”)
Where the second criteria is cells that match either string “MATCH2a” OR “MATCH2b”.
Any help would be appreciated.