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.

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

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

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

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.

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nakia Allen" wrote in message
...
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.