101Excel Hacks
    Back to Blog
    Excel formulasHack 24
    =COUNTIF function
    data analysis

    Count How Many Times One Item Appears in Another Excel List

    Excel Hack #24

    9 views
    1 min read
    2018-01-09
    Count How Many Times One Item Appears in Another Excel List

    [One-line post alert] To do the above, use the formula below: =countif(cell reference of list B, cell reference of list A item)

    [One-line post alert] To do the above, use the formula below:
    =countif(cell reference of list B, cell reference of list A item)

    Frequently Asked Questions