How to Count Cells with Text in Google Sheets ?
|
Google
|
Aug 27, 2024
|
Google
8 Steps
How to Count Cells with Text in Google Sheets ?
|
Google
|
Google
8 Steps
1
Navigate to https://docs.google.com
2
Click on a "Blank Cell" in the sheet
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
5
Close your parentheses by typing ")" and Click "Enter".
6
Type "Enter"
7
Rejected autofill as we are trying to count the total number.
8
You're finished.
By following these steps you can count cells with text in google sheets
