COUNT IF NOT

Hi! I have this formula:

=COUNTIF({G3 - Range 1}; AND(@cell >= TODAY(); @cell <= TODAY(60)))

I want to add a condition that says {G3 - Range 2} is not equal to "concluded"

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!