Counting multiple pieces of data in one cell separately

A

ArtBuyer7

I'm looking for help counting multiple pieces of data shown together
in one cell separately. Ex: A cell has "M, R" in it. How do I tally
the M's and the R's separately in my totals? Thanks!
 
J

JE McGimpsey

ArtBuyer7 said:
I'm looking for help counting multiple pieces of data shown together
in one cell separately. Ex: A cell has "M, R" in it. How do I tally
the M's and the R's separately in my totals? Thanks!
Click to expand...

one way:

=COUNTIF(A1,"*M*")

=COUNTIF(A1,"*R*")
 

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

Similar Threads

Tracked changes by multiple people modified to one 0
Split single cell into multiple cells 2
Using IF and VLOOKUP for range of cells 5
Embed the same Excel multiple times 0
Copy previous record into form field 0
Nested if then statement 2
Pasting a range to a single cell 0
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top