Two options:
=COUNTIF(E:E,"<=10")-COUNTIF(E:E,"<6")
or
=SUMPRODUCT(--(E1:E1000<=10),--(E1:E10005))
Note you can't use an entirecolumn reference in Sumproduct hence the E1000.
Regards
Rowan
"Cybertech" wrote:
I'm trying to count the number of rows that fall within a
numerical range. For example I want to count the number of rows that
contain a value 5 and <=10
I tried both count and countif and keep getting errors. Half if it is
no problem, =COUNTIF(E:E,"5") works as does =COUNTIF(E:E,"<=10") but
when I put them together I have problems.
I book uses the example {=SUM((E:E5)*(E:E<=10))} but that doesn't work
either.
Can someone point me in the correct location?
Thanks!
--
Cybertech
------------------------------------------------------------------------
Cybertech's Profile: http://www.excelforum.com/member.php...o&userid=26533
View this thread: http://www.excelforum.com/showthread...hreadid=398428