COUNT IF - CRITERIA

Options

Hello Team,

I have the following data to work on:

22-123
22-456
22-789
23-123
23-456
23-789
24-123
24-456
24-789

Where the first 22-, 23- and 24- represent 2022, 2023, 2024.

I'm trying to use the "COUNTIF" formula to count them by using, the 22, 23 and 24 as criteria, to know how many items I have per year, however it shows me 0.

How should I enter the formula to count them correctly?

Thanks in advance!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!