Look in the help index for ABSOLUTE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CJB" wrote in message
...
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