software

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,quot;T1quot;) 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,quot;T1quot;,B1:B10) assuming T1 etc is in column A and your values in
column B.

--
Ian
--
quot;Sheilaquot; gt; wrote in message
...
gt;I have a column with the text T1, T2 and T3 in the cells. I need a
gt; calculation to add all the T1's together, all the T2's together and all
gt; the
gt; T3's. Can anyone help me?
gt; --
gt; Sheila
Look at concatenate or post example and expected results
HTH

quot;Sheilaquot; wrote:

gt; I have a column with the text T1, T2 and T3 in the cells. I need a
gt; calculation to add all the T1's together, all the T2's together and all the
gt; T3's. Can anyone help me?
gt; --
gt; 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,quot;T1quot;)

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-Proquot;Sheilaquot; wrote:

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

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

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 :-)
------------------------------*------------------------------*----------------quot;Sheilaquot; gt; wrote in message
...
gt;I have a column with the text T1, T2 and T3 in the cells. I need a
gt; calculation to add all the T1's together, all the T2's together and all
gt; the
gt; T3's. Can anyone help me?
gt; --
gt; Sheila