COPY FORMULA

  • Thread starter Thread starter Stuart WJG
  • Start date Start date
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
 
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
 
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
 
Back
Top