Attached is a worksheet that is an example of what I am trying to accomplish. I want a formula for cell I4.
Column A is a list of criteria numbers. I need a formula that says if I2 is seen in column D and I3 is seen in column C, and one of the criteria codes in column A is seen in column E, then I want to sum all the values in column F.
I believe it is a sumproduct with an array or something of this nature.
Bookmarks