Excel - Formula in text count

Solved/Closed

Sam - 5 Mar 2010 à 01:33
sk - 23 Aug 2010 à 02:41

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 responses

Réponse 1 / 3

aquarelle Posts 5961 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
5 Mar 2010 à 04:57

Hello,

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

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

Best regards

Réponse 2 / 3

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 Mar 2010 à 03:41

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)

Réponse 3 / 3

sk
23 Aug 2010 à 02:41

=counta(select range)