Unfortunately, Rajesh, Countif is not that smart. You need to use Sumproduct
to achieve the desired results.

Regards,
Fred.

"rajesh" wrote in message
...
Try and function within countif.

rajesh

"A.Mourice" wrote:

plz. i need a help.
How can I use countaif with many conditions or any similar formula?