Countifs with a range based on greater than and less than


I'm having an issue writing a formula that I thought would be pretty easy. Essentially, I have a Sheet Summary of Tasks In Progress that I want to count all rows that have "Task" checked and "Progress" is less than 100% and more than 0%. My formula for Tasks Not Started works by counting only the 0% and my formula for Tasks Completed works by the 100%. I've tried several different formulas (including AND) to try to get Tasks in Progress to count everything that has "Task" checked and "Progress" displaying anything except 0% and 100% but I always get either 0 rows or all the rows.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!