Hi!

Change your lookup formulas to return "" or zero if the
lookup value is not found then SUM will work.

If you want #N/A to be displayed:

If the values are always positive:

=SUMIF(A1:A10,"0")

If the values can be negative (array entered with the key
combo of DTRL,SHIFT,ENTER)

=SUM(IF(ISNUMBER(A1:A10),A1:A10))

Biff

-----Original Message-----
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?
.