# Excel - Formula in text count

Solved/Closed
Related:

- Excel - Formula in text count
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to count names in excel - Guide

## 3 responses

aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491

Mar 5, 2010 at 04:57 AM

Mar 5, 2010 at 04:57 AM

Hello,

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

Best regards

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

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

Best regards

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Mar 5, 2010 at 03:41 AM

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)

Below example count number of cells that are not blank

=COUNTA(A1:A10)