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

Re: Excel question



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