Countifs with Wild Card

[basavarajkh]

Hi

Please tell me anyone How do I write countifs formula by using wild cards

The cell contain "HD PVR" Please find attached Links


http://speedy.sh/c8tTs/HD-PVR.xlsx


I have to write formula in cell B4 > count the number cell contan "HD PVR" in column E > in Status Sheet belongs to "Dhananjay" in column H > in Status Sheet.


Thanks in advance


Regards

Basavaraj K H

 

[Faseeh]

HI Basavaraj K H,


Try this in B4 and drag down:


=COUNTIFS(Status!E2:E758,"*HD PVR*",Status!$H$2:$H$758,"*"&$A4&"*")


Regards,

 

[basavarajkh]

Thank you lot


I edit your formula like below


=COUNTIFS(Status!E2:E758,"*" & "HD PVR" & "*",Status!$H$2:$H$758,A4)


now it's fine