Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating sum product between columns.
Can anybody help me with a formula to total the total cost for the cases
purchased? In the past I would type in cell f17: =sum(f5*$e5+f6*$e6+f7*$f7...) to the bottom of my column and copy the formula across... I'm pretty sure there's an easier, smarter way but it's beyond my realm of excel knowledge... e f g Cost Case(s) Case(s) a5 $4.00 2 a6 $4.00 4 a7 $4.00 3 a8 $4.00 4 a9 $4.00 1 a10 $1.00 2 a11 $1.00 a12 $1.00 2 a13 $4.00 2 a14 $4.00 a15 $4.00 a16 TOTAL 8 12 a17 $ TOTAL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating product of 2 cells where 1 cell is in percentage | Excel Worksheet Functions | |||
Calculating cost of product | Excel Worksheet Functions | |||
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY | Excel Worksheet Functions | |||
Sum Product if? Three columns | Excel Worksheet Functions | |||
Sum product of many pairs of columns | Excel Worksheet Functions |