Automatically excluding "#VALUE!" from "SUM" function

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I have a worksheet that column B multiplies the column A
by 0.3825 in each cell.
If I have to put a letter (such as n/a), not a number, in
column a, corresponding cell in column B becomes "#VALUE!"
and my total in column B is also distorted.
Is there a formula that I can automatically exclude the
non-numeric value from the "SUM" function?
Thank you for your help.
 
One way around this is: in B10
=IF(ISNUMBER(A10),(A10*0.3825),"")

There are other methods using the error function but these can becom
over complicated.

Hope this helps

Mik
 
Back
Top