COUNTIFS with three criteria
Answers
-
Needing help with the COUNTIFS with three criteria. It does not give me a error message, but it doesn't take into account the third criteria either. I am trying to count the amount of findings in a particular ISO Standard, so I am referencing the status sheet to find three criteria: (1) whether it is parent line, (2) which area of the company and (3) whether there is a value in the ISO standard field.
Any help would be highly appreciated.
-
Your formulas are identical and appear to be returning the correct number (which in this case is 1).
Are you expecting a different number? Not sure what the issue is. Maybe you can elaborate with what result you are expecting and we can go from there.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!