simple, counting the last character in text
Thanks for that explanation of *~*
"T. Valko" wrote:
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)="*"))
--
Biff
Microsoft Excel MVP
"JVANWORTH" wrote in message
...
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?
|