LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Summarize on 2 variables

Hoping someone can help.

I have a spreadsheet containing students from 4 schools, thru cell
2159, sorted by Student-ID (6 digit number) and last name. I would
like a summary report showing the 4 schools with each of 3 status,
free,reduced,full. Within school 105 (column A) total all students
whose status is Free, status is reduced, status is full. Do for all 4
schools.

105 Free 999
Reduced 999
Full 999
110 Free 999
Reduced 999
Full 999
510 Free 999
Reduced 999
Full 999
710 Free 999
Reduced 999
Full 999

I am currently using a pivot table to show these totals but would like
to have a 'table' at the end of the worksheet showing these as well.

Thanks in advance.
 
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
Not at all clear on use of variables and/or object variables JMay-Rke Excel Discussion (Misc queries) 11 July 4th 08 06:36 PM
Cant summarize nrs like 15.200,00 Sircantona Excel Discussion (Misc queries) 3 April 29th 08 05:59 PM
summarize PBark New Users to Excel 3 April 11th 06 04:59 PM
How do I summarize a selection? Nimbus55 Excel Discussion (Misc queries) 1 August 16th 05 11:53 PM
Summarize Data kgsggilbert Excel Discussion (Misc queries) 1 June 8th 05 09:41 PM


All times are GMT +1. The time now is 01:18 AM.

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

About Us

"It's about Microsoft Excel"