Maybe =INDEX($A:$B,COLUMN(A1),1)+INDEX($A:$B,COLUMN(A1), 2)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"tracing precedent by double clicking cel"
icrosoft.com wrote in
message ...
I have a problem... consider this example and related question

A B C
D E

1 100 100 A1+B1
A2+B2 A3+B3
2 150 150 A2+B2
3 200 200 A3+B3

See when i put formula in column c, a1 & b1 are added a give the desired
result. now in cell c2 i do not enter formula instead i drag the formula
in
c1 and drag it to cell c3. again i get the desired result. Thanks GoD.

But the problem arises when i drag the formula in c1 to its right upto e1
to
get the sum mentioned in the above table. this does not happen and what
happens is that u can c when u will do it yourself.

I hope you can get what i am trying to say. so i am looking for a
solution.
if u can help me out.

Regards.