COUNTIF with Wildcard

Hello friends,

                     today I will tell something about Countif with Wildcard, wildcard means result with keeping some character ( example "Pen") in the table or column.  In the below mentioned example we can see that in the cell A 13 the total nos. of pen count is 6, but if we count in the column A then there are only 3 nos. of Pen in the whole column. How this happened, little bit trick is the formula containing, "*", which belong some wild character in the column, i.e. how many items are carrying pen character in the whole column, i.e. simply Pen, Pencil, Gel Pen, all the words having Pen common, so countif with wild character formula count the words having a unique words in the table.

 Simply how many words in the column A3 : A11 having the character in column B13  i.e. Pen so simply 6 nos. of words have Pen character in it.

                                 

1	A	B
2	Item	Qty
3	Pen	5
4	Pencil	9
5	Binder	9
6	Pen	6
7	Gel Pen	12
8	Binder	12
9	Pencil	10
10	Binder	6
11	Pen	11
12
13	6	pen

=COUNTIF(A3:A11,"*"&B13&"*")

This is all for today and next day we will discuss a new topic.

Thanks and goodbye for now

Narendra