I need to add A column of numbers based on the criteria in a seperate column

example
col b col c
yds passing qb number
5 10
8 5
7 10
i want to add the yds passing by qb 10 and yds passing of qb 5 in a formula
that will record them in a seperate spot in a worksheet