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