Help with a running total on multiple sheets
I am new to Excel and have learned a lot recently. I have just switched over all my home budgeting items to Excel instead of paper. I have a workbook with about 15 sheets (one for each budget category). Each sheet has a running balance in column E. I would like a column on sheet 1 to simply add the newest running total in column E from the remaining sheets.
I figured out how to do a running total from multiple sheets, but it is adding all the numbers from all the E columns and not just the newest running balance. (I hope that makes sense)
Thanks so much for you help!
|