Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which should return 1 is returning 0.
T2 contains Target Geography in all. Again the above formula does not return any error but simply wrong value. And also if I skip evaluation excel calculates the correct value ie 1. On Wed, Dec 29, 2010 at 7:19 PM, Aniket Banerjee <[email protected]>wrote: > 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] >> >> >
