1
Click on a blank cell in the Sheet
Click on a blank cell in the Sheet
How to count cells with text in Google Sheets
A ready-made, step-by-step walkthrough. Preview every step below — then make it your own in seconds.
Operations
2
Type =COUNTA(ENTER YOUR DATA RANGE HERE) In this example, the data range was A2:A11 or you can just highlight all of the cells you need to count
Type =COUNTA(ENTER YOUR DATA RANGE HERE) In this example, the data range was A2:A11 or you can just highlight all of the cells you need to count
3
Click "HERE"
Click "HERE"
4
Click on the cells you need to count to specify the data range if you did not type it in the step before
Click on the cells you need to count to specify the data range if you did not type it in the step before
5
You're finished!
You're finished!
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.