=SUM(INDIRECT("B1"):INDIRECT("B6"))
--
David Biddulph

"Shawn" wrote in message
...
How do I stop the function from moving if I insert cells? For example, if
my
function is SUM(B1:B6) and I insert cells it changes it to SUM(B2:B7).....

I'd like it to stay SUM(B1:B6)