simple, counting the last character in text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know it is simple, but I'm blanked out...........

How do I count the number of cells that have an "*" as the last character?
 
I know it is simple, but I'm blanked out...........
How do I count the number of cells that have an "*" as the last character?
Click to expand...

Try this...

=COUNTIF(A1:A6,"*~*")

Set your range accordingly.

Rick
 
Here's another way just in case you forget to define the * as a text
character by preceding it with the ~:

=SUMPRODUCT(--(RIGHT(A1:A10)="*"))
 
Thanks for that explanation of *~*

T. Valko said:
Here's another way just in case you forget to define the * as a text
character by preceding it with the ~:

=SUMPRODUCT(--(RIGHT(A1:A10)="*"))
Click to expand...
 
You must log in or register to reply here.

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

Counting the number of times a character occurs in a cell 1
Counting assistance 3
Formula/Function for Counting Characters in a cell 4
testing range of cells for part of cell content 5
Adding the total # of characters in multiple cells 3
Need some help with a COUNTIF function 4
Counting Characters In A String 2
Count the times a specific character appears in a cell 3

Back
Top