adding individual cells in a column

S

Sheila

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?
 
I

Ian

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.
 
R

Ron Coderre

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
 
K

Ken Wright

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

http://www.geocities.com/jonpeltier/Excel/Pivots/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 :)
------------------------------­------------------------------­----------------
 
Top