I'm trying to make an array formula to detect the number of English characters in a range.
When I use the following for individual cells:
I get the correct values, but it only works when I extend the cells manually (but I want it to work as an array formula that extends automatically).
The above only checks if the first cell, A5, is English, then counts all the characters in the other cells without first checking if each cell is in English.
I'd also be willing to simply count all English chars in an entire range, but I ran into a similar problem with checking the language of only the first cell in the range.