Function for multiple tabs in one worksheet
I have a standard template for all tabs in one workbook (there are about 100
different tabs). What is the function to sum the same cells in each tab and carry over to a summary leadsheet? Would this be similar to running a report? Thank you! |
Function for multiple tabs in one worksheet
Assume that your summary sheet is not contained within the "sandwich"
made up of the "first" sheet and "last" sheet, and that you want to add every E5 cell from the sheets. Here's the formula you need in your summary sheet: =SUM(first:last!E5) Change those names to suit your sheet names - if you have spaces in the sheet names you will need to put apostrophes around them: =SUM('first sheet:last sheet'!E5) Hope this helps. Pete On Feb 17, 10:51*pm, Excel makes life easier <Excel makes life easier @discussions.microsoft.com wrote: I have a standard template for all tabs in one workbook (there are about 100 different tabs). What is the function to sum the same cells in each tab and carry over to a summary leadsheet? Would this be similar to running a report? Thank you! |
Function for multiple tabs in one worksheet
=SUM(Sheet2:Sheet100!A1)
Entered in a cell on Summary leadsheet. If your sheetnames are unique then the best course is to insert a new sheet just right of Summary and insert a new sheet after last sheet. Name these First and Last =SUM(First:Last!A1) When adding more sheets insert them anywhere between Fiest and Last Gord Dibben MS Excel MVP On Wed, 17 Feb 2010 14:51:02 -0800, Excel makes life easier <Excel makes life easier @discussions.microsoft.com wrote: I have a standard template for all tabs in one workbook (there are about 100 different tabs). What is the function to sum the same cells in each tab and carry over to a summary leadsheet? Would this be similar to running a report? Thank you! |
All times are GMT +1. The time now is 09:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com