Summarize on 2 variables
Assuming the following column order:
col A col B col c col d
---------- ----------- ----------- ----------
School # student ID last name meal type
with 5000 rows of data and the table is at row 5050:
col A col b col c
------ ------- ------------------
105 Free
=sumproduct(--($A$2:$A$5000=A5050),--($D$2:$D$5000=B5050))
will count all students in school 105 with Free lunch.
"Steve M" wrote:
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.
|