Excel Formulas and formatting
 

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

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


"Helen" wrote in message
...
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

Hi Bob

This still doesn't seem to work. Is it because I have other numerical
figure in the column whic form another autosum?

"Bob Phillips" wrote:

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


"Helen" wrote in message
...
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

Sorry, it should be

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


--

HTH

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


"Helen" wrote in message
...
Hi Bob

This still doesn't seem to work. Is it because I have other numerical
figure in the column whic form another autosum?

"Bob Phillips" wrote:

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


"Helen" wrote in message
...
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