Counting values in a range

Emily S

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 :)

Paul Newcome

Try this:

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