Thread: Add up worksheets

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

=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

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

"Kate" <kateehiggins2@tiscali.co.uk> wrote in message
news:44ae2895$1_3@mk-nntp-2.news.uk.tiscali.com...
> 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
>
>

Thanks Bob it does help

Kate
"Bob Phillips" <bob.NGs@somewhere.com> wrote in message
news:uQz4EyaoGHA.4380@TK2MSFTNGP04.phx.gbl...
> =SUM('Sheet1:Sheet30'!F26)
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Kate" <kateehiggins2@tiscali.co.uk> wrote in message
> news:44ae2895$1_3@mk-nntp-2.news.uk.tiscali.com...
> > 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
> >
> >
>
>