Consolidation of totals from various sheet on to one sheet

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
 
R

RagDyeR

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
 
J

Jas

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
 
Top