Using COUNTIFS with AND in Summary Sheet
Current Formula is for # Enrolled
=COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course")
I need a formula for Enrolled AND # Late Status Red X
Answers
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi IES,
As you want one more condition in the formula, you can provide another range and criterion in the formula of countifs.
Please refer following link-
If you are still facing issues, please share some screenshots for the context where you are trying to apply the formula with the fields required in it.
Thank you
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!