Count if number between two numbers in Excel?

K

Kblue74

I am trying to count how many times a number >=94 and <95 occurs in a column?
I can get it to count how many above a number or below but not in between.
 
J

JE McGimpsey

one way:

=COUNTIF(A:A,">=94") - COUNTIF(A:A,">=95")


another:

=SUMPRODUCT(--(INT(A1:A1000)=94))
 
Top