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
|