Good Evening,
My data would be say 10,12,15,35,90
my formula I tried was:
countif(range,"=12")-countif(same range,"<=35") I am looking for an answer
of 3
meaning I want to count for all the numbers between 12 and 35 inclusive.
Thanks,

Bob


"Teethless mama" wrote:

Post some samples and your formula

"bobselff" wrote:

Good Day,
I am trying to write a formula which would look down a row of cells and
give me a count if the number is greater than x and less than Y. Every one i
try (i.e. countif, sumif etc.) either returns an error in the formula or a
wrong count.

Thank you for your time and enery,

Bob