Excel - Formula in text count

Solved/Closed
Sam - Mar 5, 2010 at 01:33 AM
 sk - Aug 23, 2010 at 02:41 AM
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

aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 491
Mar 5, 2010 at 04:57 AM
Hello,

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

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


Best regards
2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 5, 2010 at 03:41 AM
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)
1
=counta(select range)
0