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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!