Add up worksheets

's Computer Specifications

I have 30 worksheets in one workbook I need to add cell F26 from each sheet
and add them up in sheet 31. Is this possible?
Thanks Kate

's Computer Specifications

=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kate" <(E-Mail Removed)> wrote in message
news:44ae2895$(E-Mail Removed)...
> I have 30 worksheets in one workbook I need to add cell F26 from each
sheet
> and add them up in sheet 31. Is this possible?
> Thanks Kate
>
>

's Computer Specifications

Thanks Bob it does help

Kate
"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =SUM('Sheet1:Sheet30'!F26)
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Kate" <(E-Mail Removed)> wrote in message
> news:44ae2895$(E-Mail Removed)...
> > I have 30 worksheets in one workbook I need to add cell F26 from each
> sheet
> > and add them up in sheet 31. Is this possible?
> > Thanks Kate
> >
> >
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How use info in Excel shared worksheets to create new worksheets	=?Utf-8?B?ZGtj?=	Microsoft Excel Worksheet Functions	0	28th Jun 2007 08:36 PM
How to hide worksheets and set marco to print those hidden worksheets?	koo7891	Microsoft Access Macros	0	22nd Apr 2007 06:05 AM
Copy data from multiple worksheets to worksheets in a number of other spreadsheets	SteveH	Microsoft Excel Discussion	5	6th Nov 2006 06:59 PM
VBA / Macro for creating new worksheets and new columns from existing worksheets	webby2006	Microsoft Excel Programming	3	25th Jul 2006 03:38 PM
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000	L Mehl	Microsoft Excel Misc	2	27th Jul 2004 07:20 PM