Excel - Formula in text count [Solved/Closed]

Report
-
 sk -
Hello,

I Need a formula in text count For Example
P=1

P+P+P+P+P= 6
What is the formula in excel please define

3 replies

Posts
7077
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 18, 2020
498
Hello,

Try with this formula, I supposed the text is into A1 :

=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,"P","")))


Best regards
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2887 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
if you want to count the cell, then you can use COUNTA function

Below example count number of cells that are not blank
=COUNTA(A1:A10)
=counta(select range)