vezerid wrote:
I am not sure I fully understand what you are subtracting. But I know
for sure how to get the expression R1+R2, then R3+R4 etc, thus you can
include the following expression in your formula

OFFSET('Sheet1'!$A$1,2*(ROW()-1),0)+OFFSET('Sheet1'!$A$1,2*(ROW()-1)+1,0)

and then subtract as necessary.

HTH
Kostis Vezerides

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