Sum excluding n/a's

Hi there,

I have a column that i want the sum of but some cells contain #n/a as the value is a lookup from a different worksheet and it doesnt contain a value.

I tried the normal SUM function but because some values are #n/a the result comes out as #n/a. Is there a way to exclude these from the SUM? I've tried SUM IF and COUNT IF but cant figure it out.

Thanks,

Tim

That works great thanks. Is there a way of multiplying two sells excluding the #n/a? Something like a MultiplyIF function, if such a thing exists!!

A B
#N/A 4
12 9
4 8
#N/A 6


Want to multiply these columns together but to exclude the #N/A, or if it is there, to return result as 0. Any ideas?

for a single cell
=IF(ISERROR(A1*B1),0,A1*B1)

for a range, entered as an array, so with shift ctrl enter instead of enter at the end

=SUM(IF(ISERROR(A1:A9*B1:B9),0,A1:A9*B1:B9))

Regards

Dav