Conditional Sum on VLOOKUP Returned Data

[Guest]

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]

Hi!

This will ignore the #N/A's

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

Get rid of the N/A's!

Biff

 

[Guest]

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]

You're welcome!

Biff

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