Using COUNTIFS with multiple conditions

edited 12/09/19 in Formulas and Functions

Trying get a count of issues in a catergory sheet that is referenced from a main sheet and then add another condition to count the categories of only the ones where the site is checked.  The first COUNTIFS works, but not the 2nd one like below .

=COUNTIFS({Day 1 Support Log Range 1}, =[Issue Category]1, {Day 1 Support Log Range 2}, <>"closed") + COUNTIFS({Day 1 Support Log Range 3}, ={qryStatus_By_Sites Range 1}, 1)

I have attached file with screen shots and formulas.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!