You don't need the =sum() function:
=C6*$C$3+D6*$D$3+E6*$E$3
And I find using ()'s makes it easier to see what's going on:
=(C6*$C$3)+(D6*$D$3)+(E6*$E$3)
And excel has a formula designed for this kind of thing:
=sumproduct($c$3:$e$3,c6:e6)
CJB wrote:
Hi, I'm having the same sort of problem. My formula is
=sum(C6*C3+D6*D3+E6*E3) ... the C3, D3 etc keeps changing to C4 ... C5 etc as
I copy the formula down. C3, D3, E3 is the price of a product.
"pinmaster" wrote:
Try this:
=SUM(INDIRECT("A1:A3"))
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496576
--
Dave Peterson