• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countifs with Wild Card

basavarajkh

New Member
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
 
Last edited by a moderator:

Faseeh

Excel Ninja
HI Basavaraj K H,


Try this in B4 and drag down:


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


Regards,
 
Last edited by a moderator:

basavarajkh

New Member
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
 
Top