How to modify fill handle properties?

[ashish]

Hi,

I am not subtracting anything. Here is the problem again-


this is sheet 1
C1
R1 10
R2 20
R3 30
R4 40
R5 50
R6 60
R7 70
R8 80


In sheet 2, I want cell Row1col1 to represent addition of cell R1C1 and

cell R2C1 of sheet 1
cell Row2col1 to represent addition of cell R3C1 and cell R4C1 of sheet

1
cell Row3col1 to represent addition of cell R5C1 and cell R6C1 of sheet

1
and so on...........


What's happening in sheet2 is after i put the formula in cell row1col1
(adding cell R1C1 and cell R2C1 of sheet1) and dragging it down,
cell Row2col1 does addition of cell R2C1 and cell R3C1
cell Row3col1 does addition of cell R3C1 and cell R4C1
and so on..........


Is there any way out to do such kind of addition.


Thanks


ashish

 

[Guest]

You can't change the way the fill handle functions. Instead, use different
formulas, something like

=SUM(OFFSET(Sheet1!RC,ROW(RC)-1,0,2,1))

 

[sunny]

Hi Duke,

Ur suggestion worked. Thanks a lot for ur help. It has definitely
helped us save a significant amount of time.

Thank You,
Sachin & Ashish