Calculating sum product between columns.

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
 
D

Domenic

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


Try...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top