Join us at GITEX 2024! Discover our solutions at Hall 4, Booth H-30 Book your live demo today.
header icon
document-icon
How to Count Cells with Text in Google Sheets ?
By Mitisha
|
Aug 27, 2024
|
document-icon Google
|
8 Steps
document-icon
How to Count Cells with Text in Google Sheets ?
By Mitisha
|
document-icon Google
|
8 Steps

1
2
Click on a "Blank Cell" in the sheet
Merged Image
3
Enter "=COUNTA(ENTER YOUR DATA RANGE HERE)" In this example, the data range was A2:A7 or you can just highlight all of the cells you need to count
4
Click on the "Cells" you need to count to specify the data range if you did not type it in the step before
Merged Image
5
Close your parentheses by typing ")" and Click "Enter".
Merged Image
6
Type "Enter"
7
Rejected autofill as we are trying to count the total number.
Merged Image
8
You're finished.
By following these steps you can count cells with text in google sheets
Merged Image