Hello, new member here & I've had a 5 year break from using Excel, but my job now calls for extensive use of it, so 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 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.
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, but I'm struggling with where to start.
I've attached a spreadsheet...
Bookmarks