Consolidation of totals from various sheet on to one sheet

  • Thread starter Thread starter Jas
  • Start date Start date
J

Jas

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
 
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!
==============================================



So simple

Many thanks

Jasb
 
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
 
Back
Top