No Nick!! I am not getting any error but the result it returns is 0 which is a wrong.
On Wed, Dec 29, 2010 at 6:21 PM, Nick Burch <[email protected]> wrote: > 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: [email protected] > For additional commands, e-mail: [email protected] > >
