Excel Formulas

Frequent Visitor

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.

1 Reply


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)