Summarize on 2 variables
Is this how your pt is setup:
........A........B................C
2...105....Free............999
3............Reduced......999
4............Full..............999
5...110...Free............999
6............Reduced.....999
7............Full.............999
Assume the range is A2:C13
Create headers for the other table like this:
...........F...........G...........H.............. .I
1...................Free.....Reduced.......Full
2.....105......................................... .....
3.....110......................................... .....
4.....510......................................... .....
5.....710......................................... .....
Enter this formula in G2:
=INDEX($C$2:$C$13,MATCH($F2,$A$2:$A$13,0)+COLUMNS( $G2:G2)-1)
Copy across then down as needed
--
Biff
Microsoft Excel MVP
"Steve M" wrote in message
...
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.
|