I'm trying to figure out a formula to count the number of rows that meet multiple criteria. I've down this before using SUMPRODUCT when the selections for each are each only one specific value. For example, column A = "One" column B = "A" and column C = "Yes".
What I am trying to do is expand on this so the selection criteria are lookups to a list of values. For example, column A is a value from a list of values in column AA, column B = is a value from a list of values in column AB, and column C = "Yes". I don't want to use add/or because the lookups lists could be quite long.
In the below example, I would want the count to be 4
Column A Column B Column C Column AA Column AB
One A Yes One A
One B Yes Two B
Two A Yes Three C
Two X Yes
Three C No
Three C Yes
Three Z Yes
I'm sure this can be done but can't figure it out! Any help would be greatly appreciated! See attached.
Bookmarks