Count text

[Kristina]

Hi.... I need to count the number of times each store appears (LEFT by 4
characters):
edar wkub
edar02
edar02
edar01
wkub01
wkub02
emur01

Result: Store "edar" appears 3 times; "wkub" 2 etc.

Thank you very much!!!

 

[T. Valko]

Try this...

=COUNTIF(A2:A7,"edar*")

=COUNTIF(A2:A7,"wkub*")

Or, using cells to hold the criteria...

B2 = edar
B3 = wkub

=COUNTIF(A2:A7,B2&"*")

=COUNTIF(A2:A7,B3&"*")

 

[Kristina]

Thank you so much, works perfectly!!

Try this...

=COUNTIF(A2:A7,"edar*")

=COUNTIF(A2:A7,"wkub*")

Or, using cells to hold the criteria...

B2 = edar
B3 = wkub

=COUNTIF(A2:A7,B2&"*")

=COUNTIF(A2:A7,B3&"*")

 

[T. Valko]

You're welcome. Thanks for the feedback!