Counting Occurances

Options

Column A shows NAMES, Column B shows Dates of occurrences (from other sheet) of those names. So a cell in Column B looks like "Date 1; Date 2; Date 3; Date 4: etc". I'm trying to count how many times the date occurs by year. So I'd like a column C called 2022 that counts how many times 2022 shows up in the list in column B. Is that possible?

Best Answer

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    edited 06/13/24 Answer ✓
    Options

    Try this formula. I'm going to assume your cross-sheet reference names below, replace with the real names.

    = COUNTIFS({Names}, NAMES@row, {Dates}, YEAR(@cell)="2022")

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    edited 06/13/24 Answer ✓
    Options

    Try this formula. I'm going to assume your cross-sheet reference names below, replace with the real names.

    = COUNTIFS({Names}, NAMES@row, {Dates}, YEAR(@cell)="2022")

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!