Copying Formulae in a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following Formula =SUM(j5,j10,j15,j20)
I want to copy along a row so the next one reads =
sum(j6,j11,j16,j21) then =sum(j7,j12,j17,j22) etc.
When I try to copy series along row (using sq. in bottom right corner) the next cell reads =sum(K5,K10,K15,K20) then sum(L5,L10,L15,L20) etc.
Is there any way without typing each seperately, that I can get the series I want?
I hope this makes sense....
 
Try this ..

Put in any cell:

=SUM(INDIRECT("J"&ROW(A1)*5+COLUMN(A1)-1),INDIRECT("J"&ROW
(A1)*10+COLUMN(A1)-1),INDIRECT("J"&ROW(A1)*15+COLUMN(A1)-
1),INDIRECT("J"&ROW(A1)*20+COLUMN(A1)-1))

This returns the functional equivalent of:
=SUM(j5,j10,j15,j20)

Copy across as needed

The next cell to the immediate right will return
the functional equivalent of : =sum(j6,j11,j16,j21)
and so on ..

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

needhelp said:
I have the following Formula =SUM(j5,j10,j15,j20)
I want to copy along a row so the next one reads =
sum(j6,j11,j16,j21) then =sum(j7,j12,j17,j22) etc.
When I try to copy series along row (using sq. in bottom
Click to expand...
right corner) the next cell reads =sum(K5,K10,K15,K20)
then sum(L5,L10,L15,L20) etc.
 
Hi!

It seems to me that you are copying the formula along
columns instead of row. Try copying the formula using
the fill handle, drag the fill handle over the range you
want to fill. Next drag and drop the formula to the
desired cell.
-----Original Message-----
I have the following Formula =SUM(j5,j10,j15,j20)
I want to copy along a row so the next one reads =
sum(j6,j11,j16,j21) then =sum(j7,j12,j17,j22) etc.
When I try to copy series along row (using sq. in bottom
Click to expand...
right corner) the next cell reads =sum(K5,K10,K15,K20)
then sum(L5,L10,L15,L20) etc.
 
Hi!

It seems to me that you are copying the formula along
columns instead of row. Try copying the formula using
the fill handle, drag the fill handle over the range you
want to fill. Next drag and drop the formula to the
desired cell.
-----Original Message-----
I have the following Formula =SUM(j5,j10,j15,j20)
I want to copy along a row so the next one reads =
sum(j6,j11,j16,j21) then =sum(j7,j12,j17,j22) etc.
When I try to copy series along row (using sq. in bottom
Click to expand...
right corner) the next cell reads =sum(K5,K10,K15,K20)
then sum(L5,L10,L15,L20) etc.
 
Back
Top