Count Characters in Range
=SUMPRODUCT(LEN(A1:A5)-LEN(SUBSTITUTE(A1:A5,{"a","b"},"")))
Thanks NateO!
© Copyright
andrewsexceltips.net
All Rights Reserved.