Hi all,

i'm struggling with the last part of this formula and i hope someone can help out

Here my situation;

Column A, C, E are "QTY"
Column B, D, F are "Product" which could be either "burger", fries", "shake"
burger has a numeric value of 120, fries has a value of 110, and shake has a value of 140.

This is my formula;

=SUM(COUNTIF(B2:F2,{"burger","fries","shake"})*{12 0,110,140})* ......

I want either of these 3 values to be multiplied with the QTY in either Column A, C, E, eg; A2*B2, C2*D2, E2*F2, and then i want the total SUM displayed in Column G Row 2

Hope i was clear enough in explaining.


Best regards