PureBytes Links
Trading Reference Links
|
Colin:
>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?
1. Create another worksheet. Say your original cells are in Sheet1 and
your new worksheet is Sheet2.
2. Everywhere you have a cell in Sheet1, put this formula in Sheet2:
(Say you're working on cell C4)
=IF(ERROR.TYPE(Sheet1!C4)=3,0,Sheet1!C4)
3. Sum up the values in the new sheet. All #VALUE! cells in the
original sheet will be zero in Sheet 2.
--
,|___ Alex Matulich -- alex@xxxxxxxxxxxxxx
// +__> Director of Research and Development
// \
// __) Unicorn Research Corporation -- http://unicorn.us.com
|