John C <johnc@stateofdenial wrote...
If there are any values that are 25 or 40, perhaps you should use INT(25) and
INT(40), just to ensure there is no rounding issues?
....

When would INT(25) and 25 or INT(40) and 40 not be the same?

Or do you mean wrap the H:H references inside INT? If so, can't be
done in COUNTIFS, which requires that its odd-numbered arguments (1st,
3rd, 5th, etc) be range references.

If the OP's problem is rounding, then the solution would be

=COUNTIFS(H:H,"=24.5",H:H,"<40.5")

And, no, there's no roundoff error with .5 when the absolute value of
the integer part is less than 10^14.