Countifs trouble

I have done this before but for the life of me I can't get it to work this time. I simply need to "count if" the "Contractor" is "X" AND "Status" is "Open" = qty


I tried  =COUNTIF(range1, criteria1) + COUNTIF(range2, criteria2)

*and many, many more.



No matter what formula I try it won't work.



Jacque Smith

Project Controls, MSR-FSR

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!