simple, counting the last character in text

[JVANWORTH]

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?

 

[Rick Rothstein \(MVP - VB\)]

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?

Try this...

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

Set your range accordingly.

Rick

 

[Roger Govier]

Hi

Try
=COUNTIF(A1:A100,"=*~*")

 

[JVANWORTH]

Thanks

Hi

Try
=COUNTIF(A1:A100,"=*~*")

 

[JVANWORTH]

Thanks

Try this...

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

Set your range accordingly.

Rick

 

[T. Valko]

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)="*"))

 

[gwen]

Thanks for that explanation of *~*

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)="*"))

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks for that explanation of *~*