SUM #n/a

[sgrech]

Hi,
I wonder if somebody can help with this. I need to sum a number of
cells, however some of these cells may contain #n/a. The sum function
doesn't like these values, can some suggest a suitable way to get
around this?/

Thanks
Simon

 

[Ron Coderre]

Try something like this:
=SUMIF(A1:A10,"<>#N/A",A1:A10)

Does that help?

Ron

 

[sgrech]

Yes thanks that works.

Cheer