Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize data
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. -- cfc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize data
use formulas on the summary sheet that refer to ranges on the other sheets,
eg =sum(sheet1!A1:a10) and so forth. "Chris" wrote: 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. -- cfc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for a way to summarize data? | Excel Worksheet Functions | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Summarize Data | Excel Discussion (Misc queries) | |||
Summarize data | New Users to Excel | |||
Summarize Data Set | Excel Worksheet Functions |