Function that counts how many characters are in a range?

[Greg Determann]

If I have 30 cells and some have only "T" in them and some may have "T C T" in them I need to count how many total characters are listed and it would be great if I could break out the T's and C's counts. Thanks in advance.

 

[Brian from Maui]

If I have 30 cells and some have only "T" in them and some may have "T C T" in them I need to count how many total characters are listed and it would be great if I could break out the T's and C's counts. Thanks in advance.

Limited testing,

=SUMPRODUCT((LEN($A$1:A10)-LEN(SUBSTITUTE($A$1:A10,D1,""))))

For T where D1 houses T

=SUMPRODUCT((LEN($A$1:A10)))

For total characters

 

[Seti]

Brian's last formula for the total number of characters will count spaces as well as the T's and C's. If you don't want spaces, try:

=SUMPRODUCT(LEN(SUBSTITUTE(A1:A10," ","")))