Calculating data between two given parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 14 Sep 2007 11:16 GMT

If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?

Thanks

Reply to this Message

Bob Phillips - 14 Sep 2007 11:23 GMT

=COUNTIF(A1:A300,">20")-COUNTIF(A1:A300,">30")

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> If i have a range of A1:A300 and the range of numbers within those cells
> could be anything from 1 to 50 how do i count cells that contain numbers
> greater than 20 but less than 31?
>
> Thanks

Reply to this Message

David Biddulph - 14 Sep 2007 11:51 GMT

Unless the numbers are contrained to being integers, it may be preferable to
use =COUNTIF(A1:A300,">20")-COUNTIF(A1:A300,">=31")

Signature

David Biddulph

> =COUNTIF(A1:A300,">20")-COUNTIF(A1:A300,">30")

>> If i have a range of A1:A300 and the range of numbers within those cells
>> could be anything from 1 to 50 how do i count cells that contain numbers
>> greater than 20 but less than 31?
>>
>> Thanks

Reply to this Message