How to use "countif" in Google Sheets | Scribe
    logged out logo

    How to use "countif" in Google Sheets

    • Google SheetsGoogle Sheets
    This Scribe shows you how to use the [[countif]] function in Google Sheets to count instances in a dataset based on 1 single criteria. For multiple criteria, use the [[countifs]] function
    Select the cell where you want your output to live
    Let's assume you want to count how many people named "Joe" are in this dataset. In the cell, type "=countif(A2:A7,"Joe")" and hit [[enter]] The [[countif]] syntax is as follows: =COUNTIF(RANGE,CRITERIA)
    There is your result!
    Documents you might like
    0 Selected
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe