Is this function only possible per cell?
When I take this range of cells I get the #value# mark.
LEN(E65:E78)-LEN(SUBSTITUTE(E65:E78;"a";""))
The LEN function you made is amazing had no idea. but if I can get this range issue fixed I'm set and done!