ding ding ding, you now get it!

If he shows a value of 25 in a cell, but in reality it is 24.999999999, then
OBVIOUSLY 25 will not be equal to INT(25). This was testing the data to
ensure that any values that show 25, and any values that show 40, are truly
25 and 40 respectively.
--
John C


"David Biddulph" wrote:

Unless that you are confident that any rounding is downwards, you'd be
better withy ROUND rather than INT.
If the cell contains 24.99999999999, INT will return 24, not 25.
--
David Biddulph

"John C" <johnc@stateofdenial wrote in message
...
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.