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

"Nakia Allen" wrote in message
...
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.