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]

How do

I get the function =SUM(Orders!N8:N2000) to ignore the cells with the
error and just add the cells with normal currency values.

Brute force-wise,

=SUMIF(range,">0")+SUMIF(range,"<0")

For more elegance, use Aladin Akyurek's suggested array (CTRL+Shift+Enter)
formula,

=SUM(IF(ISNUMBER(range),range))

Rgds,
Andy