Thursday, 13 November 2014

Count the values ending with specific character

Count the values ending with specific character
Example : A-Z

Apply the below formula to the spreadsheet and get the count of specific character ending with value entered in cell F1.

Enter "A" in cell F1 and you will get the count from column A

=COUNTIFS(A:A,"*" & F1)

No comments:

Post a Comment