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?

"Bob Umlas" wrote:

=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.

The formula looks fine to me. Check that A14 and B8:B53 contain
compatible values, i.e. if they are meant to be numbers, are you sure
that they are not text values which just look like numbers? If you are
trying to match text values, ensure that you do not have any leading or
trailing spaces.

Hope this helps.

Pete

Nakia Allen wrote:
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?

"Bob Umlas" wrote:

=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.