Give text a numeric value and multiply and add with different cells

shg · #2 01-07-2016, 09:54 AM

That's an awkward layout with interleaved columns.

Code:

     --A--- --B--- -C- --D-- -E- --F--- --G-- ---------------------------------------------H---------------------------------------------
 1    Item  Price
 2   Burger    120
 3   Fries     110
 4   Shake     140
 5
 6    Qty    Prod  Qty Prod  Qty  Prod  Total
 7        1 Burger   2 Fries   0 Shake    340 G7:=SUMPRODUCT(CHOOSE({1,2,3}, A7, C7, E7), LOOKUP(CHOOSE({1,2,3}, B7, D7, F7), $A$2:$B$4))
 8        3 Fries    1 Shake   5 Burger  1070

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
give mathematic functions numbers and link in the text	Meena2287	Word	3	09-11-2015 05:38 PM
how to give shadow or other effect to text	ketanco	Publisher	0	04-23-2015 05:19 AM
Copying specific cells to a new sheets also give sheetname	dapeamel	Excel	0	02-24-2015 09:20 AM
Sum Formula in the range with Numeric and NonNumeric data cells	Spanec	Excel	2	01-12-2012 09:15 AM
How to give line numbering to only selected text?	garlapati	Word	5	04-04-2011 02:05 PM