Why? Why? Equation works but returns a #VALUE to cell

Posted by Mike Kleimeyer on March 07, 2001 8:51 AM

This formula =sum(n(l2:l32>0)) works and in the formula editor shows returning a number but in the actual cell it returns a #VALUE error. I need to total all the cells in the range that have a number greater than zero. I cant us COUNTIF because in some cases the cells contain text and I think that will not work.

Posted by Mark W. on March 07, 2001 8:58 AM

This should be entered as an array formula. Use
Shift+Ctrl+Enter when entering this formula.

Posted by wpd on March 07, 2001 1:04 PM

I believe you can in fact use countif, even if
cells in the range contain text, blanks, etc.