COUNTIF Formula
Good afternoon, I am trying to count the # of a specific category on a different sheet by YTD. Here is the formula I am trying to use. =COUNTIF({Category}, "Procedure", {Date},IFERROR(@cell),0)=YEAR(TODAY())). Not sure what I am doing wrong. Your help will be greatly appreciated. Thank you
Best Answer
-
A small tweak with a change of Function. COUNTIFS (plural) is required when you have more than one criteria. Personally, I always use the COUNTIFS (plural) function since it can always be used regardless of how many criteria is needed.
=COUNTIFS({Category}, @cell = "Procedure", {Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
cheers,
Kelly
Answers
-
A small tweak with a change of Function. COUNTIFS (plural) is required when you have more than one criteria. Personally, I always use the COUNTIFS (plural) function since it can always be used regardless of how many criteria is needed.
=COUNTIFS({Category}, @cell = "Procedure", {Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
cheers,
Kelly
-
Thank you very much for your help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!