COUNTIF Criterion between two ranges


I'm struggling to create a COUNTIF formula. I want it to count the number of instances that either equal 7, or are greater than 7 but less than 13. I keep getting #Incorrect Argument Set

=COUNTIF({Risk Register: Timeline Range 4}, 7, OR(>7, <13))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!