Count Characters in Range

=SUMPRODUCT(LEN(A1:A5)-LEN(SUBSTITUTE(A1:A5,{"a","b"},"")))

Thanks NateO!



© Copyright andrewsexceltips.net All Rights Reserved.