This guide was created with Scribe in 23 seconds. Sign in and create your own!
Count Cells with Text in Google Sheets
Morgan Nash |
0 step |
23 seconds
Google Sheets
Navigate to [https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912](https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912)
Click on a blank cell in the Sheet
Zoom Saved
Type [[=COUNTA(ENTER YOUR DATA RANGE HERE)]] In this example, the data range was A2:A39 or you can just highlight all of the cells you need to count
Click on the cells you need to count to specify the data range if you did not type it in the step before
Zoom Saved
Close your parentheses by typing ") [[enter]]"
Rejected autofill as we are trying to count the total number
Zoom Saved
You're finished!
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key