How to summarise information from 4 work sheets

B

black_magic

I am trying to create a worksheet which is a summary of the information in 5
other worksheets. I would like the computer to automaticly sumarise this
information.

Can it be done? and if so how? I am in work an cannot access my hotmail
account. please reply to

[email protected]
 
G

Gord Dibben

Can be done but need more details like what is to be summarized and where is it
to be placed.

A typical 3-d reference formula for example is.............

=SUM(Sheet1:Sheet5!A1) which will sum all A1's on 5 sheets.


Gord Dibben MS Excel MVP
 
Top