Summarize data

[oleg_v]

Hi
i have 2 columns in one column names and in second column numbers.
the question is :if the names repeats more than ones how can i summarize all the numbers that belongs to that name


thanks

Oleg

[Bob Phillips]

Use SUMIF

=SUMIF(rng_names,selected_name,rng_values)