• 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

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
Instructions for using Google Docs without internet
Office

Instructions for using Google Docs without internet

November 2, 2024
Share the link to the sample file to create QR codes in Google Sheets
Office

Share the link to the sample file to create QR codes in Google Sheets

September 30, 2024
Proton Docs: Google Docs Alternative with End-to-End Encryption
Office

Proton Docs: Google Docs Alternative with End-to-End Encryption

September 21, 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

Instructions on how to format text on the Windows 11 notepad

Instructions on how to format text on the Windows 11 notepad

August 16, 2025
Instructions for receiving 80GB of free data from VinaPhone from August 15

Instructions for receiving 80GB of free data from VinaPhone from August 15

August 15, 2025
Online driving exam preparation: Support theory and practice

Online driving exam preparation: Support theory and practice

August 15, 2025
How to add application to your favorite bar

How to add application to your favorite bar

August 14, 2025
Instructions on how to format text on the Windows 11 notepad

Instructions on how to format text on the Windows 11 notepad

August 16, 2025
Instructions for receiving 80GB of free data from VinaPhone from August 15

Instructions for receiving 80GB of free data from VinaPhone from August 15

August 15, 2025
Online driving exam preparation: Support theory and practice

Online driving exam preparation: Support theory and practice

August 15, 2025
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

Instructions on how to format text on the Windows 11 notepad

Instructions on how to format text on the Windows 11 notepad

August 16, 2025
Instructions for receiving 80GB of free data from VinaPhone from August 15

Instructions for receiving 80GB of free data from VinaPhone from August 15

August 15, 2025
  • Home
  • Home 2
  • Home 3
  • Home 4
  • Home 5
  • Home 6
  • Next Dest Page
  • Sample Page

©2024 AnonyVietFor Knowledge kqxs hôm nay xem phim miễn phí mm88 8XBET mm88 trang chủ new88

No Result
View All Result
  • Home
  • News
  • Software
  • Knowledge
  • MMO
  • Tips
  • Security
  • Network
  • Office

©2024 AnonyVietFor Knowledge kqxs hôm nay xem phim miễn phí mm88 8XBET mm88 trang chủ new88

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