COUNTIF with AND or COUNTIFS --> Not sure how to make this work; neither formula I tried is working
=COUNTIF(AND({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))
=COUNTIFS(({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))
Best Answer
-
Hi @Paige Luben
Try this:
=COUNTIFS({2020-2021 Goal, Budget, and Performance Ti Range 2}, "Budget", {2020-2021 Goal, Budget, and Performance Ti Range 1}, "Complete")
Your COUNTIFS formula was correct but you added [ ] around the 2nd range and 2nd criteria and too much ( ) for the COUNTIFS as a whole :) . Hence the UNPARSEABLE you probably got :)
Answers
-
Hi @Paige Luben
Try this:
=COUNTIFS({2020-2021 Goal, Budget, and Performance Ti Range 2}, "Budget", {2020-2021 Goal, Budget, and Performance Ti Range 1}, "Complete")
Your COUNTIFS formula was correct but you added [ ] around the 2nd range and 2nd criteria and too much ( ) for the COUNTIFS as a whole :) . Hence the UNPARSEABLE you probably got :)
-
@David Joyeuse THANK YOU SOOOO MUCH not only did that work but I really appreciate you explaining what I did wrong. Somehow the parentheses and brackets are literally always my problem.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!