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