I have a spreadsheet taht contains many v-lookups. When no match is
returned, it displays a #n/a. If this is displayed in a range that is sumed
up, if causes the sum to also appear as #n/a. The sum function will ignore
actual text in it's calculation, but not this "error" message. How do I make
it so that the "#n/a" value will not stop SUM formulas from adding the cells
that did return a numerical value?