COPY FORMULA

S

Stuart WJG

I have a formula in row 1 with the range c1: n1 named materials so formula is
=sum(materials) however when I try and copy thsi formula down to nect row it
stays as =sum(materials).
can somebody please help
 
M

Mike H

Hi,

Do it with the formula =SUM(C1:N1) but 'manually' enter it i.e. don't select
the range to input the formula because if you do it will change to
=sum(materials). You can then drag down and the formula will increment.

Doing it this way you can keep your named range in case you use it somewhere
else.

Mike
 
M

Max

That's how it behaves, ie like a fixed range: $C$1:$N$1. If you want to
retain the defined name, and still be able to propagate the formula down
normally, ie so that it becomes in the next formula cell: =SUM(C2:N2), etc,
use this to replace the formula in your startcell:
=SUM(OFFSET(materials,ROWS($1:1)-1,))

Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Top