counif greater or less than
 

This is my current countif statement:

=COUNTIF(J3:J33,"<-10")

BUT, I want to count anytime the cells are 10 or greater positive or negative.

Please help!

counif greater or less than
 

Try

=SUMPRODUCT(--(ABS(J3:J33)=10))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537499

counif greater or less than
 

One way

=SUMPRODUCT(--(ABS(J3:J33)10))

if you are going to use countif you need to use it 2 times like

=COUNTIF(J3:J33,"<-10")+COUNTIF(J3:J33,"10")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Raza" wrote in message
...
This is my current countif statement:

=COUNTIF(J3:J33,"<-10")

BUT, I want to count anytime the cells are 10 or greater positive or
negative.

Please help!