Excel Formulas and formatting

H

Helen

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

=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)
 
H

Helen

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

Sorry, it should be

=COUNTIF(A:A,"T")*1


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top