I am trying to do a tally of a hockey pool sheet based on trades made. The first 5 trades are 5 dollars each and the 6th trade is $15. I have the player # in column A, the player's name in column B and the player's salary value in column C. I have 107 teams to tally so I would like to have a formula that would tally up the number of trades from one to five a team has made multipled by five dollars and the 6th trade is multiplied by 15 dollars. When I do the formula I get a total of $40 no matter if there is data in the cell or not.

Any help is most appreciated.