Counting a row if a word repeats 3 or more times in the cells of that row.

[xgsjx]

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.

 

[Peter_SSs]

Two things would help ..

• Update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
• Give us the sample data again with XL2BB so we can easily copy/paste to test with without a nheap of manual typing.

 

[xgsjx]

Cheers Peter, I'll update my profile.

I managed to sus out what I needed for this one, but no doubt I'll be back again soon.

Thanks again.