Hi, Formula : =*SUMIF(C1:C199,"<>#VALUE!",C1:C199)* Is evaluating wrong value ie 0 instead of the correct value.
If I do not evaluate the formula explicitly then excel evaluates the correct value. Is this a bug? If yes is there any bug filed for this? Kindly help...Thanks!!! Regards, Aniket
