Count if number between two numbers in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
one way:

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


another:

=SUMPRODUCT(--(INT(A1:A1000)=94))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNT rows on external sheet if between date range 3
Calculate the number of seconds between two times 1
I need a fx for counting numbers between numbers (between 18 - 59 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
count number of occurances between 2 values 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Count number of dates between a specified period of time 2
Counting number of times name occurs between two dates 2

Back
Top