Hi,

Thanks for your prompt reply.
Its right, but i have not to assign the range to countif. I need to solve the same that if there is more data and there are two times a merge criterion, and then i need the same, I need some advance function that can automatically search the range for my criterion and then give me the result.

Hope u understand my query.



Rgds