Navigate to [https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912](https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912)

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

Close your parentheses by typing ") [[enter]]"

Rejected autofill as we are trying to count the total number

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

Count Cells with Text in Google Sheets