Trying to add multiple table cells together, getting wrong total

[groceryguy306]

Hello
I have 13 tabs, each with their our table which consists of 4 columns in each table. in my 14th tab i want to add the same row out of each table for a total of each row.

for example i want to add tables 1 to 13 rows 1 to 4 columns b to f in my last tab.

currently im using this formula
"=Table13[@2022]+Table12[@2022]+Table11[@2022]+Table10[@2022]+Table9[@2022]+Table8[@2022]+Table7[@2022]+Table6[@2022]+Table5[@2022]+Table4[@2022]+Table3[@2022]+Table2[@2022]+Tabel1[@2022]"

but the total is wrong by roughly 400.00

 

[RobP]

I am sure you've checked, but are you sure your tables are all labelled as 1-13, and not some other number instead ?

I say that as when I create a table in sheet1, then copy it to sheet 2, ir labels it as Table13,, thenSheet3 it gives me 'Table14'

 

[groceryguy306]

I am sure you've checked, but are you sure your tables are all labelled as 1-13, and not some other number instead ?

I say that as when I create a table in sheet1, then copy it to sheet 2, ir labels it as Table13,, thenSheet3 it gives me 'Table14'

Yes, i have double checked the names of my tables, they all match

 

[Automatrix]

Are you sure that all tables are aligned so they start in the same row?

 

[groceryguy306]

Are you sure that all tables are aligned so they start in the same row?

Yes, the rows on each of the 13 tabs all correlate to the correct number I'm wanting to add together

 

[Automatrix]

How about adding one table at a time, and see when it goes wrong.

 

[groceryguy306]

How about adding one table at a time, and see when it goes wrong.

Thanks for that tip, seems as table7 was the issue for some reason.. after deleting it from the formula and then re-adding it fixxed the issue