Grand total from Spreadsheets

How do I create a grand total using multiple spreadsheet widgets and multiple column totals?  I have a budget worksheet that uses 6 separate spreadsheet widgets and I want to get a total of all Year 1 Budget requests and all Year 2 budget requests and show that as an automatic calculation within a final Total spreadsheet.  

Thank you!

I'm afraid that you cannot total multiple Spreadsheet widgets, since widgets are acting as a separate iframe in form so you cannot extract data from it.

But you could do something similar with the input table field:

If you create it in a similar way as you did with the Spreadsheet you will be able to extract total.

Let us know if you have any further questions.

Thank you!