COUNT BETWEEN 2 numbers

[AndyJr]

Hi My Friends,

I'm sorry to bother you but I've tried all day to do something that i thought was easy.

I tried to do something easy, but i had an issue. I use the COUNTIF and the COUNTIFS formula (the way it should be, i guess)

From a List of Numbers (from 0 to 5 for now) I'm trying to count how many numbers i get from a Minimum/Maximum Cell reference (J4 and J5) <- Values on this Cells are going to be dynamic.

The List of Numbers is located on Column C5 to C40.

And the formulas that i use are located in F7 and F8

I mean, I'm not looking for the 2 formulas, i just need to get a Formula with the Right value.

WHAT IM GETTING:

For example, I'm supposed to get 31 but i get 30, and most of the time it is 1 number less, but in some other columns (that are not on the sample sheet) I get the right Value
So, it gets me so nervous because in some columns it is good and other not?

Please Find the sample sheet attached

I really appreciate ladies and gentlemen...

Thank you


Andy Jr