On Tue, 2005-08-09 at 06:10, Nzman wrote: > I am having trouble using the * in the criteria part of the countif > formula. Typing in "pears.*" will not find pears1 for instance. I have a > formula in an excel spread sheet > =IF(OR((MONTH(A16)=MONTH(A15)),(A17="")),IF(WEEKDAY(A16)=$B$7,LOOKUP($B$7,$J$1:$J$7,$K$1:$K$7)&MOD((COUNTIF($C$14:C15,LOOKUP($B$7,$J$1:$J$7,$K$1:$K$7)&"?")+$B$3-1),($B$2))+1,WEEKDAY(A16)),"BOM"&MOD((COUNTIF($C$14:C15,"BOM?")+$B$5-1),($B$4))+1) > that works fine in excel and mostly works fine in OO except it dosent > count my weekdays or oems because of the countif formula not working > properly. In excel a ? in used instead of an *. When i change formula it > makes no difference. I did a test on counting cells with pears in as > follows. > Making cell A1 = "pears" and using =countif(A1;"pears") will return a 1. > Making cell A1 = "pears1" and using =countif(A1;"pears.*") will return a 0. > How do I get the second line to work. > > John Meredith. > I seem to remember solving a similar problem to your "pears" example by enabling regular expressions in calc. I don't think it will solve your larger problem as the only strings I've had it count are at the beginning of the cell, eg it wouldn't count "ripe pears".
good luck > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
