View Single Post
  #3   Report Post  
Leslie Coover
 
Posts: n/a
Default

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

"Leslie Coover" wrote in message
news:c3hIe.30$U92.23@okepread06...
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