Count Function Question

[helpme20]

Results from an athletic contest with 12 schools.

If I have a spreadsheet with 4 columns.

Column A is Athlete's name.

Column B is School Name (Column has a named range of "School")

Column C is Place (1st thru 4th) (Column has a named range of "Place")

Column D is the division that the athlete is in. (there are 20 divisions).


After Listing Each of the 12 Schools name in Column H1 -H12, what is the count function in Excel to tell me how many 1st place finishers from that particular school for Column I1-I12?

 

[shg]

Excel 2003-, =SUMPRODUCT((School=H1)*(Place=1))

2007+, =COUNTIFS(School, H1, Place, 1)