Set up your table like this (with the school number in column A on
each row of the table):

School Status Number
105 Free
105 Reduced
105 Full
110 Free
110 Reduced
110 Full
510 Free
510 Reduced
510 Full
710 Free
710 Reduced
710 Full

Suppose the Label row is 2200, then put this formula in C2201 under
Number:

=SUMPRODUCT((F$1:F$2159=A2201)*(S$1:S$2159=B2201))

This assumes that the feeder school code is in column F and the status
is column S - adjust to suit your data. Then you can copy the formula
down to C2211.

Hope this helps.

Pete

On Sep 26, 4:36*pm, 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.