On Wed, 29 Dec 2010, Aniket Banerjee wrote:
Formula : =*SUMIF(C1:C199,"<>#VALUE!",C1:C199)* Is evaluating wrong value ie 0 instead of the correct value.
Quick check - are you getting an error from the evaluation? Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
