Quote Originally Posted by FDibbins View Post
Thanks for the title change

If I understand you correctly, this formula will do what you want...
=COUNTIFS($E$3:$E$18,">=50%",$E$3:$E$18,"<=55%",$F$3:$F$18,"win",$B$3:$B$18,B23)

However, your dates in B3:B13 are 2013, but the dates you are looking for are 2014
Sir, the dates Nov. 4, Nov. 14, and Nov. 16 was not given.. sorry if misunderstood.. i just put the possible solution but i also need a formula in order for me to result for those dates at the same time the number of "win" base on the next day...

Is there any other way to do it?? thank you sir..