Count the values that contains the specific text
Example Column A contains :-
A1 = America
A2 = London
A3 = Mike
A4 = Spike
We are looking for the count of values that contains "ike". Enter "ike" in F1
Output = 2
=COUNTIFS(A:A,"*" & F1 & "*")
Example Column A contains :-
A1 = America
A2 = London
A3 = Mike
A4 = Spike
We are looking for the count of values that contains "ike". Enter "ike" in F1
Output = 2
=COUNTIFS(A:A,"*" & F1 & "*")
No comments:
Post a Comment