View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TONY M TONY M is offline
external usenet poster
 
Posts: 2
Default Summing Data Across Tabs

Is there a way to add cells from different tabs of a worksheet. I am
attempting to create a summary page that will sum from 52 tabs. I was
trying to add, for example.
Sum Tab 1-52 Cells #3. If cell three of tab 1-4 were the following
Tab 1 Cell 3 = 4
Tab 2 Cell 3 = 2
Tab 3 Cell 3 = 7
Tab 4 Cell 3 = 8
Then Cell three on my summary tab would equal 21.
How can I set up a formula to accomplish this.

Thank you