adding individual cells in a column

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

Look at concatenate or post example and expected results
HTH

"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

Not sure what you mean here.
Do you mean you want to count the number of T1s etc?
=COUNTIF(A1:A10,"T1") assuming your column is A.

Do you mean you want the sum the values in another column when column A is
T1?
=SUMIF(A1:A10,"T1",B1:B10) assuming T1 etc is in column A and your values in
column B.

--
Ian
--
"Sheila" <[email protected]> wrote in message
news:[email protected]...
>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

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

COUNTIF() will do it, but so will a Pivot Table if you are familiar with
those.

http://www.geocities.com/jonpeltier/...pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Sheila" <[email protected]> wrote in message
news:[email protected]...
>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