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:26 PM, Aniket Banerjee <[email protected]>wrote: > 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] >>> >>> >> >
