How to analysing data within spreadsheet

Okay... Take a deep breath... I understand that this is going to be very tricky to sort and may need to be broken down into a few parts.

Attached you should find our schools tracking and monitoring module to track learning.

Within 'Progress Overview' you will see that some data for P1/2 is displayed with regards to their level of understanding/skills in maths (columns J, K, L / Rows 13-29). This data is pulled from another sheet within the workbook. (You will see we are at the early stages of inputting data into this spreadsheet and so there are still a lot of blanks)

For each curricular area in school we have created a progression of learning and colour coded these. As a rule of thumb the expected level of attainment for each child is:

Nursery: Light Blue
P1: Blue
P2: Purple
P3: Pink
P4:Red
P5: Orange
P6: Yellow
P7: Green

You may notice a very narrow column down the very left hand side of 'Progress Overview' sheet that shows the progression of colours.

Some children obviously don't reach the expected level when we hoped for and others exceed the expected level.

What my wish now is for some sort of formula that will work out the number of children for each cohort (year Group) that are below, on track, or above the expected level for maths.

Back at the title screen you will see another hyperlink button titled 'How well are we doing in... Maths'. Is it possible in any way, shape or form for the information on Maths to be collected and pinged through to this sheet????

I understand spreadsheets can do a lot for us but I am pretty certain I am maybe asking a bit too much this time!

If you can help or provide any advice as to how I can complete even a small part of this then please help. My school and I would be EXTREMELY grateful for your support!

THANK YOU