Thursday, 13 November 2014

Count the values starting with specific character



Count the values starting with specific character

 Example : A-Z

 Apply the below formula to the spreadsheet and get the count of specific character starting 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