As long as you're looking for a total (or count), you could use =sumif() (or
=countif()).

=sumif(sheet1!a:a,"lemon",sheet1!b:b)

will sum the values in column B of sheet1 only if the corresponding value in
column A is Lemon.



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!

--

Dave Peterson