Do I put that into the same cell that I have the VLOOKUP formula? How would
I squeeze it in wit that formula?
"Max" wrote:
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?