Quote Originally Posted by tushardnk View Post
the formula works only for numbers it does not count the ball on which wicket is fallen "WKT".

It should count the cell in which WKT in entered.
People have provided you with things that work based on what you have told us, and now you decide to give more information that you should have provided in your first post.

I'm done wasting my time here.