Sumproduct of multiple column (same row) that meet multiple criterias

Hi...

I was wondering if you could use function of Sumproduct of multiple column (but in the same row) that meet multiple criterias.


Please find attached excel file for clarity.

Thank you very much.

First, I thank you for your response.

But unfortunately that's not what I meant.

Let me run through it:
1. It needs to check each column that meets "Criteria A" (Quantity) and at the same time check column right below it (its corresponding price) to also meet "Criteria B".
2. Multiply both column Quantity and Price

The correct answer if we do it by manual calculation ---> ((C1*C2)+(C3*C4))/C8 = 8.67 (not 9).

So in the excel file sample, it would only calculate:
((C1*C2)+(C3*C4))/C8

and not:
((C1*C2)+(C3*C4)+(C5*C6))/C8 since C5 meets "Criteria A" but C6 doesn't meet "Criteria B".

Excel Picture.jpg

Hope it clarifies.

Thank you.

Yes, that's exactley what I need.

Thanks much Glenn...