Count Cells with Text in Google Sheets | Scribe

    Count Cells with Text in Google Sheets

    • Morgan Nash |
    • 7 steps |
    • 23 seconds
    1
    Navigate to [https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912](https://docs.google.com/spreadsheets/d/1rJcrXLOw_fQhJ6eSACPIUE2eas6p5warrsW47oB92Kk/edit#gid=2069459912)
    2
    Click on a blank cell in the Sheet
    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
    5
    Close your parentheses by typing ") [[enter]]"
    6
    Rejected autofill as we are trying to count the total number
    7
    You're finished!