COUNTIFS for a range of numeric values

I have a column containing Days From Purchase. It contains numeric values from 1 to 90.

I want to create a summary value that tells me how many instances are in that column between 15 to 25.

This is what I have and it is UNPARSEABLE :

=COUNTIFS((Days from Purchase):(Days from Purchase), AND(Days from Purchase>=15,Days from Purchase<=25))

Brand new user so please don't skip anything common knowledge.

Thank you.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!