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!
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!
Try
=SUMPRODUCT(--(ABS(J3:J33)>=10))
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" <[email protected]> wrote in message
news:[email protected]...
> 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks