Summarizing raw data

Hi all,

I posted last night regarding a spreadsheet that I needed help with and I got exactly the solution I needed. The problem is, I need to further breakdown the summarized data and I'm not sure how to go about doing it...

I have attached 2 woorkbooks - "SAMPLE" which is what the report should look like and "RAW DATA" which is how I get the data.

The main issue is breaking down the raw data into floors and sections... If you look at "SAMPLE", I have a breakdown of all the floors and the rooms of each section on the floor (columns A and B). Also, while braistorming, I put together an array in columns L and M with each room number and the section it is part of, thinking I could maybe use a VLOOKUP function, but not sure how to go from here.

What I need to get from "RAW DATA" is the average of each score for each section ("SAMPLE" Columns E,G,I) and the number of responses for each section ("SAMPLE" Columns F,H,J).

I appreciate any help I can get with this!

Thanks in advance,

Sonya