Counting values in a range

Emily S
Emily S ✭✭
edited 06/23/22 in Formulas and Functions

I have a column of numbers and I would like to count when the numbers fall between a range of numbers.

For example, I would like to count numbers between 5 and 10.

So, what would the formula be?

This is what I have tried:

=COUNTIFS({P&P report - AH - 15 Jun 22 Range 2}, "<5" ">=10"))

Please help :)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!