# 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?

• Overachievers Alumni
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

• Overachievers Alumni
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!