Summing multiple values

[Marcop99]

Does anyone know a formula how to sum up multiple values associated with one variable? Basically, I would like to populate the column below that has the question marks withs the sum of the values from the "value" column associated with the variables from the "name" column.

NAME Value NAME Sum of Values

A 10 A ?

B 20 B ?

C 50 C ?

A 100

B 200

C 250

A 500

B 1,000

C 1,500

[daddylonglegs]

Try SUMIF like this in D1 copied down

=SUMIF(A:A,C1,B:B)