How do you use the wildcards to count rows in a worksheet that contain certain letters in a specified cell (the letters will be the same but may occur in different places within the text of the cell)

Dear Jacqueline

Thank you for attending Excel Advanced course.

I am not entirely sure of the question that you have asked. I am assuming that you want to count the cells in a row or columns that contain certain text.

Please refer to the file that I have uploaded with this post and let me know if this answers your query.

I have used COUNTIF function on Cell A1. If you click on Cell A1 you’ll observe the unction reads:

=COUNTIF(B3:E6,"*ow*")

B3:E6 is the range that the function is looking at
“*ow*” is the criteria it is looking for. As ow could appear anywhere in the cell therefore I have put * before and after so that it counts anywhere ow appears.

Please note that I had to type the inverted commas in the criteria.

I hope this helps in answering your query.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved . If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Attached files...

CountIf wildcard.xls