Help with COUNTIFS
Hello.
I am trying to set up a part of my metrics sheet that will count using a COUNTIFS function. I will need the conditions to be Approve and Deny, and I will need them to be able to accept each condition by year. I will attach pictures of what I mean.
So I will cross refrence this sheet using the date column which will be sorted by year (2024,2025,etc). And also the Approve column which either has the option to be Approve or Deny
I want it to end up here in my metrics sheet which I am in the process of making a dashboard. am not sure how I should use a range and criterion to only count the approve and deny for the given year as shown…
Can someone help me with the function for the last part of counting by date please?
Thanks.
Answers
-
here is the formula I'm using that isn't working…
=COUNTIFS({6AB Range 1}, "Approve", {6AB Range 2}, YEAR(@cell) = $[Column2]@row))
-
It looks like you got one too many ) at the end of your formula. My test show your formula should work otherwise.
Your Formulas should be
=Countifs({6AB Range 1}, "Approve",{6AB Range 2}, Year(@cell) = $[Column2@row)
=Countifs({6AB Range 1}, "Deny",{6AB Range 2}, Year(@cell) = $[Column2@row)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!