Countif Question

[Timothy Wright]

I have a column of numbers some of which are repeated.

I have this formula in a cell: =countif($e5:4e1000,">31<40"), but it
doesn't work.

I'm trying to figure out a way to count all of the numbers in my
column between 31 and 40.

Any help appreciated.

Thanks,

Timothy

 

[Frank Kabel]

Hi Timothy
try
=SUMPRODUCT(($E$5:$E$1000>31)*($E$5:$E$1000<40))

or as alternative syntax:
=SUMPRODUCT(--($E$5:$E$1000>31),--($E$5:$E$1000<40))

 

[Timothy Wright]

I have a column of numbers some of which are repeated.

I have this formula in a cell: =countif($e5:4e1000,">31<40"), but it
doesn't work.

I'm trying to figure out a way to count all of the numbers in my
column between 31 and 40.

Any help appreciated.

Thanks,

Timothy

Um, I had a slight error in my formula: should read,

=countif($e5:$e1000,">31<40")

 

[Timothy Wright]

Hi Timothy
try
=SUMPRODUCT(($E$5:$E$1000>31)*($E$5:$E$1000<40))

Sumproduct, yes of course, why didn't I think of that. Thanks.

 

[JMay]

=(COUNTIF(A2:A15,">="&C4)-COUNTIF(A2:A15,">"&C5))

where C4 is your lower limit
and C5 is your upper limit.

HTH

 

[CLR]

Another way..........

=COUNTIF($E5:$E1000,"<40")-COUNTIF($E5:$E1000,"<=31")


Vaya con Dios,
Chuck, CABGx3