G Guest Mar 9, 2005 #1 how do I give a letter a value then add them up in a column ie if T=1, I want to add up all the T's in the column but nothing else
how do I give a letter a value then add them up in a column ie if T=1, I want to add up all the T's in the column but nothing else
B Bob Phillips Mar 9, 2005 #2 =SUMIF(A:A,"T")*1 Thge * 1 is superfluous in this case, but if the weight is something different you need it. -- HTH RP (remove nothere from the email address if mailing direct)
=SUMIF(A:A,"T")*1 Thge * 1 is superfluous in this case, but if the weight is something different you need it. -- HTH RP (remove nothere from the email address if mailing direct)
G Guest Mar 9, 2005 #3 Hi Bob This still doesn't seem to work. Is it because I have other numerical figure in the column whic form another autosum?
Hi Bob This still doesn't seem to work. Is it because I have other numerical figure in the column whic form another autosum?
B Bob Phillips Mar 9, 2005 #4 Sorry, it should be =COUNTIF(A:A,"T")*1 -- HTH RP (remove nothere from the email address if mailing direct)
Sorry, it should be =COUNTIF(A:A,"T")*1 -- HTH RP (remove nothere from the email address if mailing direct)
