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