Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
Can these be added up like #'s in the column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
try
=countif(a:a,"x") -- Don Guillett SalesAid Software "Calculation of Text" <Calculation of wrote in message ... I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc. Can these be added up like #'s in the column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
You can use the length function to determine the number of characters in the
cell and then sum those values. The formula below sums the length of the value in A2, to the lengths of the value in A3 and so on. =SUM(LEN(A2),LEN(A3),LEN(A4),LEN(A5)) -- Kevin Backmann "Calculation of Text" wrote: I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc. Can these be added up like #'s in the column? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
Something like?
=countif(A1:A100,"=X") =countif(A1:A100,"=XX")*2 etc HTH "Calculation of Text" wrote: I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc. Can these be added up like #'s in the column? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
=COUNTIF(A:A,"x")+COUNTIF(A:A,"xx")*2+COUNTIF(A:A, "xxx")*3 Vaya con Dios, Chuck, CABGx3 "Calculation of Text" wrote: I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc. Can these be added up like #'s in the column? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I caculate text in a column?
Actually, this is probably what you wanted.
=SUMPRODUCT(--(LEN(H2:H50)-LEN(SUBSTITUTE(H2:H50,"x","")))) -- Don Guillett SalesAid Software "Calculation of Text" <Calculation of wrote in message ... I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc. Can these be added up like #'s in the column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |