Count text

K

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

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&"*")
 
K

Kristina

Thank you so much, works perfectly!!

T. Valko said:
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&"*")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top