I've had a 5 year break from using Excel, but my job now calls for extensive use of it, so (re) learning all I can.
I’m hoping someone could point me in the right direction with this one (I've tried searching, but I'm not sure what I'm looking for to put in a search).
What I’m wanting to do is show how many children that are in each school that have 3 or more “High” ASN needs. I'll also be doing it with mix of "High" & "Medium". For the "High" example, I want to count rows 2, 5, 11 & 13 for Bass Primary. Row 9 for Drum Academy. Row 8 for Synth Secondary. I don't need their names, just how many there are for each school.
So I know I want to check columns D-H and count “High” in each row, then if it shows 3 or more times for the school, count it as 1. I dare say this is a simple formula & I think it's a COUNTIFS, but I'm struggling with where to start.
I've attached a pic of the sheet.
I’m hoping someone could point me in the right direction with this one (I've tried searching, but I'm not sure what I'm looking for to put in a search).
What I’m wanting to do is show how many children that are in each school that have 3 or more “High” ASN needs. I'll also be doing it with mix of "High" & "Medium". For the "High" example, I want to count rows 2, 5, 11 & 13 for Bass Primary. Row 9 for Drum Academy. Row 8 for Synth Secondary. I don't need their names, just how many there are for each school.
So I know I want to check columns D-H and count “High” in each row, then if it shows 3 or more times for the school, count it as 1. I dare say this is a simple formula & I think it's a COUNTIFS, but I'm struggling with where to start.
I've attached a pic of the sheet.