Calculating sum product between columns.

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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
 
Donna said:
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
Click to expand...


Try...

=SUMPRODUCT($E5:$E15,F5:F15)
 
Back
Top