Forum Discussion
Excel Formulas
Is there a formula for accumulating only those values whichmeet a condition. Example: Add the score for any player who is on a specified team and ignore the scores for anybody on a different team.
Let's say you have player names in A2:A100, team names in B2:B100 and scores in C2:C100.
You want to add the scores of players in "Team A".
=SUMIF(B2:B100, "Team A", C2:C100)
If you have the name of the team in a cell, say K1:
=SUMIF(B2:B100, K1, C2:C100)