If you to count the occurrences of T1's, T2's, etc, try something like this:

For values in A1:A100

To count T1's
C1: =COUNTIF($A$1:$A$100,"T1")

Alternatively:
B1: T1
C1: =COUNTIF($A$1:$A$100,B1)

B2: T2
C2: =COUNTIF($A$1:$A$100,B2)
etc

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Sheila" wrote:

I have a column with the text T1, T2 and T3 in the cells. I need a
calculation to add all the T1's together, all the T2's together and all the
T3's. Can anyone help me?
--
Sheila