Count Cells with Text in Google Sheets
5 steps | 23 seconds | Created by Morgan from Scribe
1
2
Click on a blank cell in the Sheet
Zoom Saved
3
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
4
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
5
Close your parentheses by typing ") ENTER"