CODEWITHSUNDEEP
excel
ackshooairy
ackshooairy

Reputation: 151

Total multiple tables Excel 2013

I am attempting to sum multiple tables' subtotals together to create a grand total. I've found a method to do so by naming the table and and then using =sum(tableName[columnName]). Therefore I could just add several of them together to achieve my result.

However, when I look at the pre-loaded templates, there is one called Family Monthly Budget where they have a total table that sums multiple tables showing only a single entry =totalExpenseProjected. When I click that cell, it highlights as a formula, but gives no indication as to how its calculated and I cannot recreate it using my own spreadsheet.

enter image description here

Can anyone offer insight on how to use the microsoft method?

Upvotes: 0

Views: 75

Answers (1)

Byron Wall
Byron Wall

Reputation: 4010

If you go into the Formulas->Name Manager you will see this named range is really a mess of a SUM formula:

=SUM(Actual1,Actual2,Actual3,Actual4,Actual5,Actual6,Actual7,Actual8,Actual9,Actual10,Actual11,Actual12,Actual13)

That SUM is using other named ranges. A sample of the formula in Actual1 is:

=Housing[[#Totals],[Actual]]

It then repeats that for the other 12 Actual references.

enter image description here

Upvotes: 1

Related Questions