COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions.
This is the formula I am using =
=COUNTIFS({Training Tracker Range 2}, "Completed", {Training Tracker Range 3}, "2024")
Any help would be greatly appreciated!!
Answers
-
HiThe formula syntax looks fine. Here are some things to check.
Does range 3 contain the value 2024 or is it a date?
Are both ranges the same size, in other words are there rows that are in one range but not the other?Can you try with just one of the criteria and then the other to see which could be causing the problem.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!