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