How do you apply the =SUM(COUNTIFS(DECENDANTS()) functions with 3 or more criteria?
I am using the =SUM(COUNTIFS(DECENDANTS()) functions and have successfully applied it for 1 criteria set with the following..
=SUM(COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "Staff"))
and also successfully applied it for 2 criteria set with the following...
=SUM(COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "FT2"), (COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "IC")))
but have not been able to replicate this formula when 3 or more criteria is required to produce the information i need.
How do I apply these functions with 3 or more criteria when using COUNTIFS?
Answers

What is the desired result? Are you trying to add multiple COUNTIFS together? Are you getting an error or an unexpected result?
Right off I would say try this and see if it corrects the problem. If it does not, I would need more detail as to exactly what you are trying to accomplish.
=SUM(COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "FT2"), COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), "IC"))
EDIT:
Give this a try first...
=COUNTIFS(DESCENDANTS([Contract Type Code]764), "TCH", DESCENDANTS([Instructor Type Lookup]764), OR(@cell = "FT2", @cell = "IC"))
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
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!