Adding VLOOKUP

[Guest]

Greetings,

I have the following formula, but it only returns one value although the
search criteria appears more than once in the array:

IF(ISNA(VLOOKUP(A14,'21'!$B$8:$H$53,7,FALSE))=TRUE,0,VLOOKUP(A14,'21'!$B$8:$H$53,7,FALSE))

Currently, this formula looks up a name in a different worksheet within a
workbook, in this case the worksheet tab labeled "21". I want it to add the
dollar amounts for every item in column 7 for each instance the name appears
in the B column instead on only returning the first value obtained when the
name is found in column B. Please help! I have a bit of a deadline.

Thank you for your time.

 

[Bob Umlas]

=SUMPRODUCT(--('21'!$B$8:$B$53=A14),$H$8:$H$53)

 

[Guest]

Thank you very much, Bob! I really appreciate the quick response!

 

[Guest]

You are going to kill me, but it keeps returning zero when the total should
be $14.27. Could you take a look at it again.....pretty please?

 

[RagDyer]

Try this:

=SUMPRODUCT(('21'!$B$8:$B$53=A14)*'21'!$H$8:$H$53)