=SUMPRODUCT(--(B1:B100="district number"),C1:C100)
adjust to suit


"plunk25" wrote:

I have an excel sheet with two columns that I need to pull data from. One
column contains employee names, the other contains a district number for each
employee, and the other contains the number of classes taken for each
employee.

I need to create another worksheet that contains the total number classes
taken per district. How would I go about doing this?