Hi

Assuming you have Lemon in A2 of Sheet1. In Sheet2 you have multiple
entries in col A2 down with Lemon among other names and $$ value in col B2
down. In B2 of Sheet1, place the below formula.
eg
Sheet 1,
A2 B2
Lemon =SUMIF(Sheet2!A1:A10,A2,Sheet2!B1:B10)

Sheet 2,
A2 B2
Lemon 10
Orange 5
Pear 3
Lemon 10
Orange 5
Pear 3
Lemon 10
Lemon 10
Orange 5

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"LMR29" wrote:

I am trying to use a VLOOKUP to add multiple numbers with the same heading in
another sheet. For Example in Sheet 1 I have a name (Lemon) in sheet 2 I have
multiple $ amounts with the name Lemon. I want to add the total amounts for
all purchases made by lemon. I tried using the VLOOKUP but it only gives me
the first occurence of Lemon. How do I add up the totals for all of their
purchases? Thanks!