Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum letters ex. d+d+d=3d
Can I sum up specific letters in a range of cells?
for example: d+d+d=3d |
#2
|
|||
|
|||
=COUNTIF(A1:A10,"d")
KL "Steve" wrote in message ... Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
#3
|
|||
|
|||
Not really. You can use a formula such as:
=SUMPRODUCT(--(A1:A100="d"))&"d" -- Vasant "Steve" wrote in message ... Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
#4
|
|||
|
|||
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,"d","") & "d" In article , "Steve" wrote: Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
#5
|
|||
|
|||
Actually, if you need to count every single occurence of :d" in
multi-character strings in a range, you can use: =SUMPRODUCT(LEN(A1:A4)-LEN(SUBSTITUTE(A1:A4,"d",""))) if you want to count all the multi-character strings in a range where "d" occurs at least once: =COUNTIF(A1:A10,"*d*") Regards, KL "KL" wrote in message ... =COUNTIF(A1:A10,"d") KL "Steve" wrote in message ... Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
#6
|
|||
|
|||
Ah ... I missed that possible interpretation, JE. Perhaps it's a combination
of yours and mine! <g Regards, Vasant "JE McGimpsey" wrote in message ... One way: =LEN(A1)-LEN(SUBSTITUTE(A1,"d","") & "d" In article , "Steve" wrote: Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
#7
|
|||
|
|||
Back to the other problem :-)
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Ah ... I missed that possible interpretation, JE. Perhaps it's a combination of yours and mine! <g Regards, Vasant "JE McGimpsey" wrote in message ... One way: =LEN(A1)-LEN(SUBSTITUTE(A1,"d","") & "d" In article , "Steve" wrote: Can I sum up specific letters in a range of cells? for example: d+d+d=3d |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
column headings in numbers vs letters | Excel Discussion (Misc queries) | |||
Columns in letters vs numbers | Excel Discussion (Misc queries) | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) |