To count cells containing text in Google Sheets, we will use 2 functions in Google Sheets : COUNTA and COUNTIF . With these 2 functions, users can count cells containing text in a certain data range, or more simply, in just 1 line. In particular, users can count non-blank cells with a special character they want to find. The following article will guide you to count non-blank cells in Google Sheets.
1. Count cells containing text in Google Sheets
If you are looking for the number of cells containing any text or numbers then use this method 1. This method will count the number of all non-blank cells in the specified data range.
Step 1:
Open the data table in Google Sheets, in the quantity result input box, we will use the COUNTA function and then select the data area to count the cells containing text.
We will enter the function formula =COUNTA(B21:B30) and press Enter to execute.
Step 2:
You will then see the number of cells containing text as shown below.
2. Count cells containing text in specific Google Docs
If you want to find the number of cells that contain a specific text string or number, you need to use the CountIf function. With this function, you can specify a text string and then the function counts only the cells that contain that text string.
We will enter the formula =COUNTIF(B21:B30;"Quoc Oai") and press Enter.
Immediately we will see the result is 1. There is only 1 cell in the data area containing 1 character Quoc Oai.
3. Count cells containing Google Sheets text with other characters
If you want to count cells that contain specific text with characters or other content, you can still use the Countif function, but the formula will be different. This method will count cells that contain the specified text, regardless of the content.
In the result box, we will enter the formula = COUNTIF (B21:B30;"*Quoc Oai*") and then press Enter.
Then we will see result 3, there are 3 cells containing the text Quoc Oai along with other content or characters.
Discover how to create a Wiki page in Microsoft Teams effortlessly. This ultimate guide covers step-by-step instructions, tips, and best practices to boost your team's knowledge sharing and productivity. Perfect for beginners!
Stuck on Microsoft Teams "Error S" screen? Discover proven, step-by-step solutions to fix Microsoft Teams Error S fast. Clear cache, restart, update & more for seamless teamwork. Works on latest versions!
Struggling with Microsoft Teams proxy error on Windows 10? Discover step-by-step fixes to resolve proxy authentication issues, connection failures, and more. Get Teams running smoothly in minutes with our expert guide.
Tired of Microsoft Teams Town Hall Event Error ruining your events? Get step-by-step fixes for scheduling, access, and registration issues. Restore seamless virtual town halls today with our ultimate guide.
Discover the simplest way to download Microsoft Teams for Mac, MacBook Air, and MacBook Pro. Step-by-step instructions, system requirements, and troubleshooting tips for seamless installation in the latest version. Get started now!
Stuck with Microsoft Teams Web Login Error? Get instant fixes for common issues like "Something went wrong" or login loops. Step-by-step guide to resolve Teams web login problems and stay productive. Updated with latest browser tweaks.
Struggling with Microsoft Teams Error 657rx Update Failed? Discover step-by-step fixes, from quick restarts to advanced troubleshooting, to get your Teams app updated and running smoothly in minutes. No tech skills required!
Tired of Microsoft Teams "VDI Error" Lag freezing your video calls? This ultimate guide delivers step-by-step fixes for VDI environments like Citrix and VMware. Optimize performance now for lag-free collaboration!
Struggling with Microsoft Teams "Join Meeting Error"? Discover proven steps to solve it via direct links. Quick fixes for seamless joining – no tech skills needed!
Discover simple steps to test your Microsoft Teams audio and camera before a call. Ensure crystal-clear sound and video for professional meetings every time with our easy guide. Perfect for desktop, mobile, and web users.
Struggling with Microsoft Teams Error 53003 Access Denied? Discover proven, step-by-step fixes to resolve it quickly. Clear cache, update Teams, bypass proxies & more for seamless collaboration. Works on Windows, Mac & web!
Master uploading custom backgrounds to Microsoft Teams with this easy step-by-step guide. Personalize your meetings effortlessly on desktop, web, or mobile for a professional edge.
Struggling with Microsoft Teams "Error on Phone" on iOS or Android? Discover step-by-step fixes for calls, permissions, network issues, and more. Get back to seamless teamwork fast!
Tired of Microsoft Teams OneDrive error blocking file sharing? Follow our expert step-by-step guide to fix sync issues, permissions errors, and more quickly. Get back to seamless collaboration today!
Struggling with Microsoft Teams screen flickering? Discover step-by-step solutions to fix this annoying error, from disabling hardware acceleration to driver updates. Get smooth video calls today!
