With 10 worksheets in one workbook each with totals, how can I automatically
transfer these totals to a new worksheet to give an overall summary of the
10 sheets.

I am not into gobbledygook so I need simple idiots understanding assistance.

All help gratefully received

Please reply to Group

JasB

Couldn't you simply use

=Sheet1!A10
=Sheet2!A10
etc
etc

Where A10 on each sheet has the totals

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

So simple

Many thanks

Jasb


"Dave Hawley" <(E-Mail Removed)> wrote in message
news:4046f548$0$193$(E-Mail Removed)...
> Couldn't you simply use
>
> =Sheet1!A10
> =Sheet2!A10
> etc
> etc
>
> Where A10 on each sheet has the totals
>
> ***** Posted via: http://www.ozgrid.com
> Excel Templates, Training & Add-ins.
> Free Excel Forum http://www.ozgrid.com/forum *****

You could also total a particular cell in all 10 sheets, and place that
total in one cell.

If for example, every sheet had it's own total displayed in B25, then this
formula will "total the totals":

=SUM(Sheet1:Sheet10!B25)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Jas" <postmaster@[127.0.0.1]> wrote in message
news:R2D1c.504$(E-Mail Removed)...
So simple

Many thanks

Jasb


"Dave Hawley" <(E-Mail Removed)> wrote in message
news:4046f548$0$193$(E-Mail Removed)...
> Couldn't you simply use
>
> =Sheet1!A10
> =Sheet2!A10
> etc
> etc
>
> Where A10 on each sheet has the totals
>
> ***** Posted via: http://www.ozgrid.com
> Excel Templates, Training & Add-ins.
> Free Excel Forum http://www.ozgrid.com/forum *****

Thanks, I think I will have to delve into some of the more serious stuff in
excel.
I used to do it all in basic or assembler databases but supporting Dos does
not seem to be popular these days.

JasB

"RagDyeR" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You could also total a particular cell in all 10 sheets, and place that
> total in one cell.
>
> If for example, every sheet had it's own total displayed in B25, then this
> formula will "total the totals":
>
> =SUM(Sheet1:Sheet10!B25)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "Jas" <postmaster@[127.0.0.1]> wrote in message
> news:R2D1c.504$(E-Mail Removed)...
> So simple
>
> Many thanks
>
> Jasb
>
>
> "Dave Hawley" <(E-Mail Removed)> wrote in message
> news:4046f548$0$193$(E-Mail Removed)...
> > Couldn't you simply use
> >
> > =Sheet1!A10
> > =Sheet2!A10
> > etc
> > etc
> >
> > Where A10 on each sheet has the totals
> >
> > ***** Posted via: http://www.ozgrid.com
> > Excel Templates, Training & Add-ins.
> > Free Excel Forum http://www.ozgrid.com/forum *****
>
>
>