Counting Numbers in an Interval

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" <[email protected]> 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
>

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")

In article <c3hIe.30$U92.23@okepread06>,
"Leslie Coover" <[email protected]> wrote:

> 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")


Leslie Coover <[email protected]> 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
>
>

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" <[email protected]> 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
>

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")

In article <c3hIe.30$U92.23@okepread06>,
"Leslie Coover" <[email protected]> wrote:

> 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")


Leslie Coover <[email protected]> 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
>
>

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

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" <[email protected]> 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
>

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")

In article <c3hIe.30$U92.23@okepread06>,
"Leslie Coover" <[email protected]> wrote:

> 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")


Leslie Coover <[email protected]> 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
>
>