How To Sum Cells Across Multiple Spreadsheets

  1. Create a tab called named ‘Start’. Place it at the far left of all the tabs you would like to add.
  2. Create a tab called named ‘End’. Place it at the far right of all the tabs you would like to add.
  3. On the tab where your formulas are use a formula like this to add all the cells, rows, or columns together on your data tabs.

=SUM(Start:End!A1)