where row 7 is your numbers and row 5 is the winning numbers will give the
number of matches for for 7

=IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5)))
--
Don Guillett
SalesAid Software

"DarkNight" wrote in message
...
hello again, can some one hlep with this formula,

=IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G $4=G7),"!! JACKPOT
!!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7 ),"1st 5
Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1s t 4
Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3
Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls",""))))

its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7
dont know if everyone knows how the lotto dream numbers works
but you must match a minimum of 1st 2 numbers to win
so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls
,
jackpot

theres probably an easyer way to do the samething but i aint got a clue on
it...