# Thread: Running Totals in Multiple Sheets

1. ## Running Totals in Multiple Sheets

Hello! I would like to learn how to create a spreadsheet where you can have running totals in multiple sheets within a workbook. An example is if you are working on yearly stats, and you want to compare from 2012 on through current years. Sheet 1 will indicate "Current", Sheet 2 will indicate 2014, Sheet 3 will indicate 2013 and Sheet 4 will indicate 2012. What I want to learn is how to create the formula so that the information from each sheet will automatically insert into my Current sheet. I'm not real sure what that is called. Does anyone know?

Thanks!

2. ## EXCEL for beginners with example and images

Originally Posted by Randallzg1rl
I would like to learn how to create a spreadsheet where you can have running totals in multiple sheets within a workbook.
Try see tutorial Sum values from multiple worksheets or see another links

eg.
Code:
`=SUM('20014:20012'!B2)`
or
Code:
`=SUM('20014'!B2;'20013'!B2;'20012'!B2)`
These formulas above, SUM values from the cell B2 of the respective worksheets

If you want learn Excel, try see Excel for beginners with examples and screenshots.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•