CountIfs X does not contain...

I am trying to get a formula to function and am having trouble.

=COUNTIFS({KBeaver Workload Range 1}, "Complete", {KBeaver Workload Range 3}, "1", {KBeaver Workload Range 4}, NOT(CONTAINS("E:", @cell)), {KBeaver Workload Range 4}, NOT(CONTAINS("M:", @cell)))

This is attempting to count tasks completed in Q1 by looking for the "Complete" status, then looking for a "1" in quarter, then filtering out non-tasks (does not contain "E:" and does not contain "M:").

However, the formula above only gets me "Incorrect Argument Set".

Help?


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!