How to summarise information from 4 work sheets
 

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

How to summarise information from 4 work sheets
 

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

On Mon, 18 Jun 2007 01:00:03 -0700, black_magic
wrote:

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