I want to count cell range one that has a value of "January" and cell range two that is not a value of "Water". Is there a formula for this? I could do a COUNTIFS and add all the values except " New" but that would be a long formula.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!