Countif Question

T

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
 
F

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

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
Click to expand...

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

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

JMay

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

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

HTH
 
C

CLR

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

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


Vaya con Dios,
Chuck, CABGx3
 
Top