I can use the following formula to accomplish what I need, but it is not very efficient, as I have to type a formula for every letter from A-Z, whether that letter is even used.

=COUNTIF(G4:BB4,"a*")
I would prefer to do it dynamically, so it would only count the letters that are present. The count of the letters are derived from the first letter of every word within a row.

So, if cells A1, B1, C1 equal blue, green, black, respectively, then the count would be G=1 and B=2. That means one word was found that starts with the letter 'G' and two words were found that start with the letter 'B'.

The range is G4:BB4 and each roll down to G126:BB126. I assume this will require an array formula.


Hope that makes sense!