• Home
  • News
  • Software
  • Knowledge
  • MMO
  • Tips
  • Security
  • Network
  • Office
AnonyViet - English Version
  • Home
  • News
  • Software
  • Knowledge
  • MMO
  • Tips
  • Security
  • Network
  • Office
No Result
View All Result
  • Home
  • News
  • Software
  • Knowledge
  • MMO
  • Tips
  • Security
  • Network
  • Office
No Result
View All Result
AnonyViet - English Version
No Result
View All Result

Lesson 108: How to count cells containing text in Excel

AnonyViet by AnonyViet
January 25, 2023
in Office
0

This article will show you how to count cells with text in Excel.

Join the channel Telegram of the AnonyViet 👉 Link 👈

How to count cells containing text in Excel

1a. Using the COUNTIF function and the asterisk

to count cells that contain text.

Lesson 108: How to count cells containing text in Excel 12

1b.  You can also create an array to count cells that contain text.

Lesson 108: How to count cells containing text in Excel 13

1 C.  You can also use the SUMPRODUCT function to count cells that contain text as shown below.

Lesson 108: How to count cells containing text in Excel 14

2a.However, when writing numbers or Boolean (TRUE or FALSE) and spaces, errors are not counted as text.

Lesson 108: How to count cells containing text in Excel 15

2b.  The formula below helps you to count cells that contain text and Booleans.

Lesson 108: How to count cells containing text in Excel 16

3a.  Enter a space in cell A4.  The COUNTIF function in step 1a and step 2a also counts cells with characters containing spaces.

Lesson 108: How to count cells containing text in Excel 17

3b.  The COUNTIFS function below counts cells with text and excludes cells with space characters.

Lesson 108: How to count cells containing text in Excel 18

Note: the COUNTIFS function in Excel counts cells based on two or more conditions. In addition, you can also view many other excel articles

here.

The article achieved: 5/5 – (100 votes)

Tags: cellscountExcelLessontext
Previous Post

How to create a Windows 7Gb Azure VPS for free

Next Post

Good news! Windows 11 Build 22557 can now Drag & Drop Taskbar

AnonyViet

AnonyViet

Related Posts

How to add Watermark to Google Docs to protect copyright
Office

How to add Watermark to Google Docs to protect copyright

April 19, 2026
Instructions on how to hide formulas in Excel to secure data
Office

Instructions on how to hide formulas in Excel to secure data

February 6, 2026
Top who creates the most beautiful presentation slide today
Office

Top who creates the most beautiful presentation slide today

September 23, 2025
Automatically check and correct spelling errors on Google Docs
Office

Automatically check and correct spelling errors on Google Docs

February 23, 2025
Instructions for downloading Google Docs files easily on any device
Office

Instructions for downloading Google Docs files easily on any device

December 18, 2024
Launching AI image creation feature on Google Docs
Office

Launching AI image creation feature on Google Docs

November 20, 2024
Next Post
Good news!  Windows 11 Build 22557 can now Drag & Drop Taskbar

Good news! Windows 11 Build 22557 can now Drag & Drop Taskbar

0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Recent News

How to install the cute Bongo Cat mouse pointer for Windows

How to install the cute Bongo Cat mouse pointer for Windows

April 29, 2026
Tips for pinning the step counter to the iPhone screen to monitor your health

Tips for pinning the step counter to the iPhone screen to monitor your health

April 28, 2026
How to turn off password suggestions on iPhone: Prevent Safari from auto-filling passwords

How to turn off password suggestions on iPhone: Prevent Safari from auto-filling passwords

April 27, 2026
Instructions for looking up prescriptions on VNeID instead of paper medical books

Instructions for looking up prescriptions on VNeID instead of paper medical books

April 26, 2026
How to install the cute Bongo Cat mouse pointer for Windows

How to install the cute Bongo Cat mouse pointer for Windows

April 29, 2026
Tips for pinning the step counter to the iPhone screen to monitor your health

Tips for pinning the step counter to the iPhone screen to monitor your health

April 28, 2026
How to turn off password suggestions on iPhone: Prevent Safari from auto-filling passwords

How to turn off password suggestions on iPhone: Prevent Safari from auto-filling passwords

April 27, 2026
AnonyViet - English Version

AnonyViet

AnonyViet is a website share knowledge that you have never learned in school!

We are ready to welcome your comments, as well as your articles sent to AnonyViet.

Follow Us

Contact:

Email: anonyviet.com[@]gmail.com

Main Website: https://anonyviet.com

Recent News

How to install the cute Bongo Cat mouse pointer for Windows

How to install the cute Bongo Cat mouse pointer for Windows

April 29, 2026
Tips for pinning the step counter to the iPhone screen to monitor your health

Tips for pinning the step counter to the iPhone screen to monitor your health

April 28, 2026
No Result
View All Result
  • Home
  • News
  • Software
  • Knowledge
  • MMO
  • Tips
  • Security
  • Network
  • Office

wpDiscuz
0
0
Would love your thoughts, please comment.x
()
x
| Reply