I have a list of names in Column A. Some names end with an asterisk "*". Is there a way to count how many names in a specific range have an asterisk on the end and display the total number? I tried:
SUM(RIGHT(A1:A5,1)="*")
This didn't work. I also tried:
SUM(IF(RIGHT(A1:A5,1)="*",1,0))...