View Single Post
 
Old 01-07-2016, 09:20 AM
boeff boeff is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2016
Posts: 1
boeff is on a distinguished road
Question Give text a numeric value and multiply and add with different cells

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
Reply With Quote