=SUM Function

[uplink600]

Hi

I have a simple =SUM function on a worksheet which adds the values in
column. Trouble is some of the values are #value!
errors and the =SUM function returns the same error. How do
I get the function =SUM(Orders!N8:N2000) to ignore the cells with th
error and just add the cells with normal currency values.

Please advise

Thanks

V

 

[Andy Brown]

VC,

See reply in worksheet functions.

Rgds,
Andy