Counting Numbers in an Interval

  • Thread starter Thread starter Leslie Coover
  • Start date Start date
L

Leslie Coover

MS Excel 2000

For 25 numbers in the range A1:A25 how can I count
the ones that are >= 6.41 and < 10.07?

Thanks!

Les
 
try something like this

=countif(datarange,">6.41")-countif(datarange,">10.07")
 
The answer to this question was previously posted (excuse my post) see
Trevor Shuttleworth

=SUMPRODUCT(--($A$1:$A$25>=$D$6),--($A$1:$A$25<$E$6))

where $D$6 = 6.1 and $E$6 = 10.7 etc.

Thanks, sorry for the needless post.

Les
 
One way:

=SUMPRODUCT(--(A1:A25>=6.41),--(A1:A25<10.07))

another:

=COUNTIF(A1:A25,">=6.41") - COUNTIF(A1:A25,">=10.07")

another:

=COUNTIF(A1:A25,"<10.07") - COUNTIF(A1:A25,"<6.41")
 

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

How to generate random numbers from a range of cells? 3
Adding letters instead of numbers 2
COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A") 6
Count alpha value in a column. 5
Calculate average in intervals 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
COUNTIF 15
How to get the sum of B:C by counting the instances that a nameappears in range A 8

Back
Top