=SUM(INDIRECT("A"&ROW()&":"&ADDRESS(ROW(),COLUMN()-1)))

--
Regards,
Tom Ogilvy


"Andy" wrote in message
...
I was wondering if i could do this, if so how?

I have a sum that goes through the same row. Everytime i insert a column
i
want it to automatically to include that inserted range.

Example:
A B C D
1
2
3

Cell C1 is suming Ranges A1:B1. Now if i insert the column before column
C,
i want the sum to be able to pick up that inserted range to sum ranges
A1:C1
automatically

is there a way??