Summarize data

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have several worksheets with exactly the same layout, but different data
based on educational programmes. I want to summerize the data in one sheet,
but have them in a way that this sheet still looks the same as the other
worksheets. This sheet then serves as a total of the other sheets.
The information in the sheets displays the name of the lecturer, subjects
etc for different programmes. I want them all to be consolidated in the
summerized sheet which will then enable me to do a calculation of the number
of subjects etc that all lecturers offer.
 
use formulas on the summary sheet that refer to ranges on the other sheets,
eg =sum(sheet1!A1:a10) and so forth.
 
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

Need to merge worksheets - Excel 2003 0
Excel 2007 - Summarizing Data 2
Summarizing data 2
Summarize data from multiple sheets 2
Summary from multiple sheets 1
filtering data for analysis 6
Create sorted list based on cell values 7
Cannot copy worksheet to another file 2

Back
Top