You could get there with sumproduct, but countif can handle it in two steps:
=countif(a:a,"250")-countif(a:a,"=2000").

"WBTKbeezy" wrote:

I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?