I am looking to create a multi-function formula- Count when the course is X or X AND status complete
I am summerizing data for a dashboard in a secondary sheet and need to find if two courses of many are selected AND the status is complete. I have the column before with the counting of the two courses and need to add on the completion status either by referencing the previous column or in a formula by itself and even after reviewing all the similar questions and help articles, I can't seem to get it to work:
This formula works for the previous column- =COUNTIF({xxx 2022 data input sheet Range 1}, "Course X") + COUNTIF({xxx 2022 data input sheet Range 1}, "Course Y")
Can't seem to add the additional criteria?
=COUNTIFS({xxx 2022 data input sheet Range 1}, "course x") + COUNTIFS({xxx 2022 data input sheet Range 1}, "course y") OR(COUNTIF({xxx 2022 data input sheet Range 3}, "Complete")
Best Answer
-
Brilliant @ChloeSmith thank you, that worked!
Answers
-
Would the formula below work?
=COUNTIFS({xxx 2022 input sheet Range 1}, "course x", {xxx 2022 data input sheet Range 3}, "Complete") + COUNTIFS({xxx 2022 input sheet Range 1}, "course y", {xxx 2022 data input sheet Range 3}, "Complete")
-
Brilliant @ChloeSmith thank you, that worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!