How to Total Data From Several Spreadsheets Onto One in Excel

Save

Managing the data in a large Excel workbook can be overwhelming. Often, a large workbook will consist of multiple sheets that organize different tables and have different calculations. To get a handle on a large workbook, you can create a summary sheet that abstracts and totals information from other sheets. Excel lets you accomplish this by creating a standard formula.

  • Open the Excel workbook that contains several sheets you want to total.

  • Click the sheet name tab at the bottom of the Excel workbook that you want to hold the final total. Click an empty cell within that sheet where you want to see the total. Enter an equal sign.

  • Click the tab for the next sheet. Click the cell on the second sheet that you want included in the total. Enter a plus sign.

  • Click the tab for the third sheet. Click the cell on the third sheet that you want to add to the total. Continue entering a plus sign and clicking on cells in each sheet that you want to include in the total.

  • Press "Enter" when you have added all the cells from the different sheets. You should see the total on the first sheet where you started your formula. The formula should look something like this:

    =Sheet2!B3+Sheet3!C9+Sheet4!D6+Sheet5!E10

Tips & Warnings

  • It's useful to calculate a subtotal on each sheet first if each sheet contains a range of cells you want to total. To do so, go to a blank cell on each sheet and enter "=SUM(range of cells)" replacing "range of cells" with a range, such as "A2:A25." Once you have a subtotal, you can use that cell to add to the grand total on the original sheet.

References

  • Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!