formula to create a single count covering multiple conditions

Could use the multiplicatons, another wat is use a double --


=SUMPRODUCT(--($D$2:$D$12=$A23),--($C$2:$C$12="School"))

see attchement

The formula you would want for D23 using SUMPRODUCT would be:

=SUMPRODUCT(--($D$2:$D$12=$A23),--($C$2:$C$12=D$21),--(MATCH($A$2:$A$12&"@"&$C$2:$C$12,$A$2:$A$12&"@"&$C$2:$C$12,0)=(ROW($A$2:$A$12)-ROW($A$2)+1)))
copied down

Wow
Thanks DonkeyOte

It works

Pretty clever formula. Way beyond my comprehension.

and I was able to extend the formula you posted to work out the Successul "School" Team Types in a District - eg

=SUMPRODUCT(--($D$2:$D$12=$A23),--($C$2:$C$12=D$21),--($E$2:$E$12="Successful"),--(MATCH($A$2:$A$12&"@"&$C$2:$C$12,$A$2:$A$12&"@"&$C$2:$C$12,0)=(ROW($A$2:$A$12)-ROW($A$2)+1)))

Thanks again

Shane