Forgot to add a sheet to formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
=SUM(First:Last!F8)+=SUM(First:Last!F9)+ etc.

is the simplest way

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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)
 
Back
Top