Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#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) "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 |
#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? "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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) | |||
Cell formatting or formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions |