How to summarise information from 4 work sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarising information from different sheets in a summary sheet 2
how to link multiple columns to multiple worksheet totals / functi 5
summaries on alternative sheets 6
VLOOKUP formula for multiple worksheets 4
summary values across worksheets within the same workbook 2
Relative worksheet reference for multiple worksheets in a workbook 5
Summarise data from several worksheets in a workbook 2
I cannot enter information in excel sheet, info bounces to top 2

Back
Top