If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forgot to add a sheet to formula.
I'm creating a workbook regarding the traveling expenses of my teammates.
Every sheet and tab have their name and I'm summing the in summary sheet in the workbook. Then I realised that I've forgot to add another one sheet into the formula in summary. Here is the example: Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8 So how do I add the missing name / sheet to this formula. There are a lot of these formulas in the summary sheet. Thank You |
#2
|
|||
|
|||
Forgot to add a sheet to formula.
Put a first and last sheet around all sheets in question and use
=SUM(First:Last!F8) I f all sheets are in one set (without any other sheets in-between you can replace first by the first of those sheets and the last with the last of those sheets, maybe something like =SUM(Jofri:Ili!F8) so you are doing far too much work. Otherwise use edit replace and replace the last sheet with the last sheet and the added sheet Find what Ili!F8 replace with Ili!F8+nameF8 replace all -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Syahira" wrote in message ... I'm creating a workbook regarding the traveling expenses of my teammates. Every sheet and tab have their name and I'm summing the in summary sheet in the workbook. Then I realised that I've forgot to add another one sheet into the formula in summary. Here is the example: Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8 So how do I add the missing name / sheet to this formula. There are a lot of these formulas in the summary sheet. Thank You |
#3
|
|||
|
|||
Forgot to add a sheet to formula.
but what if I have multiple cells? Not just F8 only?
"Peo Sjoblom" wrote: Put a first and last sheet around all sheets in question and use =SUM(First:Last!F8) I f all sheets are in one set (without any other sheets in-between you can replace first by the first of those sheets and the last with the last of those sheets, maybe something like =SUM(Jofri:Ili!F8) so you are doing far too much work. Otherwise use edit replace and replace the last sheet with the last sheet and the added sheet Find what Ili!F8 replace with Ili!F8+nameF8 replace all -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Syahira" wrote in message ... I'm creating a workbook regarding the traveling expenses of my teammates. Every sheet and tab have their name and I'm summing the in summary sheet in the workbook. Then I realised that I've forgot to add another one sheet into the formula in summary. Here is the example: Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8 So how do I add the missing name / sheet to this formula. There are a lot of these formulas in the summary sheet. Thank You |
#4
|
|||
|
|||
Forgot to add a sheet to formula.
=SUM(First:Last!F8)+=SUM(First:Last!F9)+ etc.
is the simplest way -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Syahira" wrote in message ... but what if I have multiple cells? Not just F8 only? "Peo Sjoblom" wrote: Put a first and last sheet around all sheets in question and use =SUM(First:Last!F8) I f all sheets are in one set (without any other sheets in-between you can replace first by the first of those sheets and the last with the last of those sheets, maybe something like =SUM(Jofri:Ili!F8) so you are doing far too much work. Otherwise use edit replace and replace the last sheet with the last sheet and the added sheet Find what Ili!F8 replace with Ili!F8+nameF8 replace all -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Syahira" wrote in message ... I'm creating a workbook regarding the traveling expenses of my teammates. Every sheet and tab have their name and I'm summing the in summary sheet in the workbook. Then I realised that I've forgot to add another one sheet into the formula in summary. Here is the example: Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8 So how do I add the missing name / sheet to this formula. There are a lot of these formulas in the summary sheet. Thank You |
#5
|
|||
|
|||
Forgot to add a sheet to formula.
Here is an other way
List all of the sheet names in cells M1:Mn, let's say M1:M3 in this example, and then use =SUMPRODUCT(SUMIF(INDIRECT(M1:M3&"!F8:F15"),"")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Syahira" wrote in message ... but what if I have multiple cells? Not just F8 only? "Peo Sjoblom" wrote: Put a first and last sheet around all sheets in question and use =SUM(First:Last!F8) I f all sheets are in one set (without any other sheets in-between you can replace first by the first of those sheets and the last with the last of those sheets, maybe something like =SUM(Jofri:Ili!F8) so you are doing far too much work. Otherwise use edit replace and replace the last sheet with the last sheet and the added sheet Find what Ili!F8 replace with Ili!F8+nameF8 replace all -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Syahira" wrote in message ... I'm creating a workbook regarding the traveling expenses of my teammates. Every sheet and tab have their name and I'm summing the in summary sheet in the workbook. Then I realised that I've forgot to add another one sheet into the formula in summary. Here is the example: Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8 So how do I add the missing name / sheet to this formula. There are a lot of these formulas in the summary sheet. Thank You |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
Change sheet name in formula | kojimm | Worksheet Functions | 2 | July 6th, 2005 09:44 AM |
Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
formula needed | Darrell | New Users | 0 | May 5th, 2005 10:25 PM |
Sheet name in formula | Kimberly | Worksheet Functions | 2 | March 18th, 2004 06:17 PM |