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
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
486
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 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!