How to summarise information from 4 work sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

black_magic - 18 Jun 2007 09:00 GMT

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

ross.millar@gtuk.com

Reply to this Message

Gord Dibben - 18 Jun 2007 22:03 GMT

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

>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
[quoted text clipped - 4 lines]
>
>ross.millar@gtuk.com

Reply to this Message