Sum of text in cell range

[mdileep]

Good evening friend, I am hoping one of you can help me.
Cell range
A1 A2,A3,A4,A5 Text TOTAL
P, P, P, P, P 5 but if
P, PP, P, PP, P 7
with counts or with a combination of function without any helper column
Thanks.

 

[arthurbr]

Try

=SUMPRODUCT(--(LEN(A1:A5)))

 

[mdileep]

Try

=SUMPRODUCT(--(LEN(A1:A5)))

Works fine, Thank you very much.

 

[arthurbr]

You're welcome

 

[mdileep]

You're welcome

What about for following Sir,
Cell range
A1:A7,
Result in A8=Text TOTAL(P&PP),
Result in A9=Text Text TOTAL Off

P, OFF, P,PP,OFF,PP A8=6, A9=2

Thanks.

 

[Fluff]

How about

+Fluff v2.xlsm
	A
1	P
2	OFF
3	P
4	PP
5	OFF
6	PP
7
8	6
9	2
Helper

Cell Formulas
Range	Formula
A8	A8	=SUMPRODUCT((A1:A7="P")+(A1:A7="PP"),LEN(A1:A7))
A9	A9	=COUNTIF(A1:A7,"OFF")

 

[mdileep]

How about

+Fluff v2.xlsm
	A
1	P
2	OFF
3	P
4	PP
5	OFF
6	PP
7
8	6
9	2
Helper

Cell Formulas
Range	Formula
A8	A8	=SUMPRODUCT((A1:A7="P")+(A1:A7="PP"),LEN(A1:A7))
A9	A9	=COUNTIF(A1:A7,"OFF")

Working fine Sir, am unable to wrote farmula for A8.
Thank You !

 

[Fluff]

am unable to wrote farmula for A8.

Not sure what you mean by this.

 

[mdileep]

Not sure what you mean by this.

I am near about reach to farmula for cell A9, but work on whole day am nor reach to farmula as u described in cell A8.

 

[Fluff]

I'm sorry but I have no idea what you mean.