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

Paul Newcome

Try this:

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

Emily S

Thanks for your response Paul. I tried the above formal but couldn't get it to work. For the @cell, please could you let me explain where I should be linking to?

Andrée Starå

Hi @Emily S

I hope you're well and safe!

Do you get an error message?

Can you paste the exact formula?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You shouldn't need to do anything with the "@cell". It should work exactly as is so long as you are properly creating the cross sheet reference. Are you getting an error or an unexpected count?

Emily S

Thanks, both. I have tried the formula suggested by Paul again and it is now working! Must have been my Friday brain not working. Thanks so much for your responses and help.

Andrée Starå

@Emily S

Excellent!

Glad you got it working!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!