Count Items In Numbers

You can count the number of times a text string appears in a Numbers spreadsheet column using the COUNTIF function. The function can be hard-coded to look for text, or it can use the value of another cell.

Comments: 2 Responses to “Count Items In Numbers”

    Jeannie
    8 years ago

    This post, with instructions on how to use CountIf is really really helpful for novice researchers needing to see the frequency of words when analyzing text. And therefore not having to buy expensive software!

    Thank you, Gary.

    Shirley
    8 years ago

    That was so very useful as I have to count Computer Club members who are PC, who are Mac and who are Both. You just made my job a lot easier!
    Thank you!

Comments Closed.