How to sum a column with errors
It's better to fix the #N/A errors but sometimes you may want to know if
there is an error.
This will sum a range and ignore any #N/A errors:
=SUMIF(A1:A10,"<#N/A")
Biff
"blkane" wrote in message
...
I have a column where the cells contain a vlookup formula for an exact
match
only. If there is no match, the value N/A# is returned. However, I would
like to be able to sum the values that the vlookup does find.
How do you write the formula so that instead of returning N/A# it returns
zero or blank if the vlookup can't find a match?
Thanks
|