I need help with my COUNTIFS formula


I am trying to get a count of rows on a sheet that are not Completed AND are not a Sub-Task. My formula works on a syntax level, but it is not coming back with the right answer. Can someone help me figure out what I'm doing wrong?

=COUNTIFS({PMO Support Tasks Range 5}, "<>*Completed*", {PMO Support Tasks Range 1}, "<>*Sub-Task")

@Paul Newcome tagging you because you are a whiz with formulas!

Kelly L. Gabel


Tech-Savvy Academy



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!