Hi Sailor,
I am using numerous VLOOKUP functions (including the "FALSE" option)
accross a row to extract exact values from the same range, which may
or may not contain the look-up value. I then want to sum accross the
row to give me a running total. The problem is that VLOOKUP returns
"#N/A" when an exact match is not found; which then returns a "#N/A"
error in the sum function.
you have to avoid #n/a with a formula like
=if(iserror(vlookup(something), 0, vlookup(something))
here the " 0 " is shown instead of the error, this will allow you to
sum up everything. Instead of " 0 " you can use anything that will
allow the sum-function to work (eg. texts like "not available", "---",
"", etc).
arno
|