Two way tables in Excel

[enola]

I have provided data sample and the query table which I need to fulfill. I will appreciate a quick, systematic approach to populating the query table below.

Data Sample:

Area	School	ECD Enrollment (Boys and Girls)	Primary Enrollment (BOYS)	Primary Enrollment (GIRLS)	ECD Classes Offered	Primary Classes Offered	# Teachers assigned to school (Primary and ECD)	Total enrollment	Total classes offered	Teachers per class	PTR	PTR Buckets
Oredo	SCHOOL FOR THE BLIND	0	0	0	3	6	9	0	9	1.00	0.00	A
Akoko Edo	OSI P/S AIYEGUNLE	138	220	180	3	6	3	538	9	0.33	179.33	D
Akoko Edo	OSOSO P/S OSOSO	75	263	250	3	6	5	588	9	0.56	117.60	D
Akoko Edo	OSU P/S UNEME OSU	22	64	96	3	6	4	182	9	0.44	45.50	D

Buckets	Total number of schools	Total pupil enrollment (this must include ECD Enrollment & Primary Enrollment)	% of schools in that bucket with enough teachers to have a minimum of 1:1 ratio of Teachers Assigned to Total Classes Offered
PTR equal to or greater than 0, but less than 10	xx	xx	xx
PTR equal to or greater than 10, but less than 15	xx	xx	xx
PTR equal to or greater than 15, but less than 20	xx	xx	xx
PTR equal to or greater than 20	xx	xx	xx
TOTAL	xx	xx	xx

 

[pecoflyer]

Please post a sample sheet so we can work on it. Thx ( and BTW, "Hello" and " Thanks in advance" are not considered as being rude on the forum )

 

[enola]

Hi Pecoflyer! Sorry I seemed rude there .... I was preoccupied with this excel roadblock. Looked everywhere and still can't figure out how to do this in an efficient manner using excel. PFA copy of the data. TIA!