How do I add cells from different worksheets?
I cannot get either of these methods to work for me. Am I doing something
wrong? "Jim Rech" wrote: Assuming the amounts are on the same cell on each worksheet use a formula like this: =SUM(Sheet1:Sheet5!A1) Otherwise you'd need a formulas like this: =Sheet1!A1+Sheet2!B2+Sheet3!C3+.. -- Jim Rech Excel MVP "ExcelErin" wrote in message ... |I am trying to add totals from 5 separte worksheets on the last worksheet | which I am calling a summary page. Can anyone share with me how to do this? I | tried the Sum button and then holding control as I click on each total on the | different worksheets but it doesn't seem to be working. |
All times are GMT +1. The time now is 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com