Conditional Summing

[keej015]

I feel the answer to my question is quite simple, but i cant seem to figure it out.

Column A: Column B:
Andy 70
Dave 50
Eric 40
Andy 30
Eric 50
Chris 10

How can i make Excel sum all numbers in Column B, where for instance 'Andy' is in column A. In other words, i wanna sum all of Andy's scores automatically.

Whats the easiest way to do this?

[keej015]

I think i already got the answer! I used the correct formula, but filled out the arguments wrong!

sum.if (translated out of dutch).

[Whizbang]

Just in case someone comes along via a search and wants a clarification on the solution you found for yourself, here is the formula.

=SUMIF(Range, Criteria, [Sum_Range])

Meaning, if "Range" is equal to "Criteria" then sum the corresponding values in "[Sum_Range]". [Sum_Range] is optional. If "Range" and [Sum_Range] are the same range, then you can omit [Sum_Range]

In the case provided by keej015, the formula would be.

=SUMIF(A:A,"Andy",B:B)