adding individual cells in a column
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" wrote in message
...
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
|