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.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!