S
Steve
Can I sum up specific letters in a range of cells?
for example: d+d+d=3d
for example: d+d+d=3d
K
KL
=COUNTIF(A1:A10,"d")
KL
KL
V
Vasant Nanavati
Not really. You can use a formula such as:
=SUMPRODUCT(--(A1:A100="d"))&"d"
=SUMPRODUCT(--(A1:A100="d"))&"d"
J
JE McGimpsey
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,"d","") & "d"
=LEN(A1)-LEN(SUBSTITUTE(A1,"d","") & "d"
K
KL
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
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
V
Vasant Nanavati
Ah ... I missed that possible interpretation, JE. Perhaps it's a combination
of yours and mine! <g>
Regards,
Vasant
of yours and mine! <g>
Regards,
Vasant
B
Bob Phillips
Back to the other problem 
Vasant Nanavati said: