How do I count cells that are between two numbers in Excel?

I need a formula to count the number of cells in a range that are between 10 and 10.000:

I have:

=COUNTIF(B2:B292,>10 AND <10.000) 

But how do I put the comparison operators in without getting a formula error?

Answers


If you have Excel 2007 or later use COUNTIFS with an "S" on the end, i.e.

=COUNTIFS(B2:B292,">10",B2:B292,"<10000")

You may need to change commas , to semi-colons ;

In earlier versions of excel use SUMPRODUCT like this

=SUMPRODUCT((B2:B292>10)*(B2:B292<10000))

Note: if you want to include exactly 10 change > to >= - similarly with 10000, change < to <=


Need Your Help

Create a Laravel Blade Form with no action

javascript php forms laravel blade

I want to create a Laravel Blade Form with no action. I want to handle all with JavaScript. In HTML I would do:

How to represent directed cyclic graph in Prolog with direct access to neighbour verticies

prolog cyclic-graph

I need to construct directed graph (at runtime) with cycles in Prolog and I am not sure know how to represent it. My requirement is that I need to get from one vertex to his neigbour in a constant ...