Conditional Sum on VLOOKUP Returned Data
 

Hello,
I am trying to perform a SUMIF type function where the data range is
returned from a VLOOKUP function (so there are several #N/A's). i don't know
if there is a better way to perform the function I need, but basically I need
to be able to sum data in a specific column (where the values in the column
are based on VLOOKUP's). Can anyone help with this?

Thank you so much!
Liz

Hi!

This will ignore the #N/A's

=SUMIF(A1:A100,"<#N/A")

Get rid of the N/A's!

Biff

"Liz" wrote in message
...
Hello,
I am trying to perform a SUMIF type function where the data range is
returned from a VLOOKUP function (so there are several #N/A's). i don't
know
if there is a better way to perform the function I need, but basically I
need
to be able to sum data in a specific column (where the values in the
column
are based on VLOOKUP's). Can anyone help with this?

Thank you so much!
Liz

Biff -
Thank you for you help in solving this problem. I had the formula right,
except I had the quotation marks around the #N/A instead of in front of the
<. How frustrating! Oh well, I do appreciate your help tho!

Take it easy,
Liz

"Biff" wrote:

Hi!

This will ignore the #N/A's

=SUMIF(A1:A100,"<#N/A")

Get rid of the N/A's!

Biff

"Liz" wrote in message
...
Hello,
I am trying to perform a SUMIF type function where the data range is
returned from a VLOOKUP function (so there are several #N/A's). i don't
know
if there is a better way to perform the function I need, but basically I
need
to be able to sum data in a specific column (where the values in the
column
are based on VLOOKUP's). Can anyone help with this?

Thank you so much!
Liz

You're welcome!

Biff

"Liz" wrote in message
...
Biff -
Thank you for you help in solving this problem. I had the formula right,
except I had the quotation marks around the #N/A instead of in front of
the
<. How frustrating! Oh well, I do appreciate your help tho!

Take it easy,
Liz

"Biff" wrote:

Hi!

This will ignore the #N/A's

=SUMIF(A1:A100,"<#N/A")

Get rid of the N/A's!

Biff

"Liz" wrote in message
...
Hello,
I am trying to perform a SUMIF type function where the data range is
returned from a VLOOKUP function (so there are several #N/A's). i
don't
know
if there is a better way to perform the function I need, but basically
I
need
to be able to sum data in a specific column (where the values in the
column
are based on VLOOKUP's). Can anyone help with this?

Thank you so much!
Liz