I was suggesting if his number in his data set showed 25 or 40 (but in
actuality is not quite 25 or 40), then check to see if 25=INT(the cell that
shows 25).
--
John C


"Harlan Grove" wrote:

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.