Supademo Logo
Supademo Logo

Try Supademo

How to count cells with text in Google Sheets

Leveraging Built-in Functions for Accurate Text Count
Get Started
Blurred step underneath chapter
Demo Image 2
Demo Image 3

How to count cells with text in Google Sheets

Author Image

Nithileashwar Shanmugam

Updated: Aug 05, 2024

Description

Click through a step-by-step, interactive demo walkthrough of Google, powered by Supademo.

Steps

1
How to count cells with text in Google Sheets
2
Start by clicking on an empty tab.
3
Next, type in 'COUNTA(ENTER YOUR DATA RANGE HERE)' in this field.
4
Then, enter the range of cells you want to count.
5
Click on the tick to confirm your inputs.
6
Finally, press 'Ctrl+Enter' to autofill and get your count
7
Create a Supademo in seconds
How to count cells with text in Google Sheets