SUM Function

  • Thread starter Thread starter uplink600
  • Start date Start date
U

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
 
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.
Click to expand...

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
 
Back
Top