Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY FORMULA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY FORMULA
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 "Stuart WJG" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY FORMULA
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 --- "Stuart WJG" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |