#1   Report Post  
Old April 28th 09, 09:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default 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   Report Post  
Old April 28th 09, 09:24 PM posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 510
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a way to summarize data? Rich Excel Worksheet Functions 0 September 19th 06 06:05 PM
How to cause a pivot tables to not summarize data - just report the data Greybeard Excel Discussion (Misc queries) 0 July 27th 05 10:21 PM
Summarize Data kgsggilbert Excel Discussion (Misc queries) 1 June 8th 05 09:41 PM
Summarize data blstone New Users to Excel 1 May 11th 05 10:18 PM
Summarize Data Set Jim Excel Worksheet Functions 6 April 7th 05 03:46 PM


All times are GMT +1. The time now is 02:50 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017