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
|