Save this Scribe
Count Cells with Text in Google Sheets
Created by Morgan from Scribe
Click on a blank cell in the Sheet
=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
Close your parentheses by typing ")
Morgan made this Scribe in 23 seconds.
Show Me How
Favorite this Scribe?
Add to your favorites for easy access and receive notifications for any changes.