Countif formula between numbers

[dandigger]

I'm have a bad day and can't figure this simple question out. I want Excel to
count a column of numbers and show the the total cells with values between
100 and 125.
The formula I have thus far is '=countif(H5:H125,">=125<=100")
why is this not working???

 

[Don Guillett]

This has been asked about a dozen times today. Homework assingment?
=sumproduct((rngA>100)*(rngA<200)). modify to suit

 

[Ron de Bruin]

Try this one

=SUM(COUNTIF(H5:H125,{"<=100",">=125"}))

 

[dandigger]

Thanks both of you. I forgot about Array functions.
And no, this is for my work, something I'm doing on my own. Sorry, I looked
at the first couple pages here and didn't see anything similar based on the
subject.
Thanks again