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

i need formula count number of cells in range between 10 , 10.000:

i have:

=countif(b2:b292,>10 , <10.000)  

but how put comparison operators in without getting formula error?

if have excel 2007 or later use countifs "s" on end, i.e.

=countifs(b2:b292,">10",b2:b292,"<10000")

you may need change commas , semi-colons ;

in earlier versions of excel use sumproduct this

=sumproduct((b2:b292>10)*(b2:b292<10000))

note: if want include 10 change > >= - 10000, change < <=