[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re[2]: Excel question



PureBytes Links

Trading Reference Links

GG> There is a sumif function. Sum over the range ignoring values that
GG> ="#Value". Check the help menu for more syntax.


GG> I have many columns of numbers I want to sum, but several of the cells
GG> contain #VALUE!. They didn't resolve from other calculations. Is there a
GG> way to exclude the cells that have #VALUE! as manually fixing them would
GG> be too tedious?

    Another    way   would   be   to   place   the   formula
    "=If(IsError(xx),"",xx)"  in  the  offending  series  of
    cells  where  xx is your original formula. Just copy and
    paste the formula as necessary.
   

-- 
Dave Nadeau
Fort Collins, CO