Paul has two values that I would like to identify and add up.

Use SUMIF
In D1, copied down: =SUMIF(A:A,C1,B:B)
where the unique names are listed in C1 down
(watch out for the unique name typos!)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"sross002" wrote:
How would I look up a value in a list and return multiple corresponding
values and then add them up?

A B C
Paul 155 Pauk
Jake 34
Paul 145
Ann 222

=VLOOKUP(C1,$A$1:$B$4,2,TRUE))

Paul has two values that I would like to identify and add up.

Does anyone know of such a formula?