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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating sum product between columns.
something like:
=SUMPRODUCT((F5:F15),(E5:E15)) -- Gary''s Student - gsnu200852 "Donna" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating sum product between columns.
In article ,
Donna wrote: 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 Try... =SUMPRODUCT($E5:$E15,F5:F15) -- Domenic http://www.xl-central.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating sum product between columns.
That's perfect! Thanks so much...
"Gary''s Student" wrote: something like: =SUMPRODUCT((F5:F15),(E5:E15)) -- Gary''s Student - gsnu200852 "Donna" wrote: 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 |
Reply |
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 |