PLZ HELP! Circular Reference Warning in calculated column

[shiegabbai]

First of all, thanks for any help!

http://postimg.org/image/mptrthkxj/

I have a table, pic above, with dates and rows and the last column is the TOTALS column for each row. When i make the formula =Sum(A2,A3,A4) it all works, but i have like 50 of these tables and i need to add columns for new dates. The problem being, these new columns are not included in the formula and I therefore need to adjust each formula, which takes hours for the amount of tables and formulas i have.
I want to make the TOTALS cell sum up the entire row EXCEPT the TOTALS cell, that way when i add new columns they will still be included in the formula.
The problem is, a cell cant include itself, i always get the Circular Reference error, which makes sense.

How do I make the formula something along the lines of =sum(Row1-cellTotals) ???

 

[Fazza]

Welcome, What about this, or some variation to suit your set up?

=SUM(OFFSET($A2,,,,COLUMN()-1))

hth

 

[Marcelo Branco]

Or (assumes Table name = Table1)

=SUM(OFFSET(Table1[@],,,,COUNTA(Table1[#Headers])-1))

M.