software

This is my current countif statement:

=COUNTIF(J3:J33,quot;lt;-10quot;)

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

Please help!


Try

=SUMPRODUCT(--(ABS(J3:J33)gt;=10))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=537499One way

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

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

=COUNTIF(J3:J33,quot;lt;-10quot;) COUNTIF(J3:J33,quot;gt;10quot;)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Razaquot; gt; wrote in message
...
gt; This is my current countif statement:
gt;
gt; =COUNTIF(J3:J33,quot;lt;-10quot;)
gt;
gt; BUT, I want to count anytime the cells are 10 or greater positive or
gt; negative.
gt;
gt; Please help!