Friends! I found the solution by using countifs() function. I used the formula as - =COUNTIFS($D$2:$D$55,"N",$C$2:$C$55,">10",$C$2:$C$ 55,"<16")

It worked and it gave me a good relief. Thanks anyway friends...

See you soon in this forum again probably with a new challenge :-P