Possibly ..

=SUMPRODUCT(--(ABS(N2:N2000)5),--(ABS(N2:N2000)50))

Note that this will not count those equal to 50.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Aleks" wrote in message
...
Outstanding!!! Thank yoy!
How about
counting cells in selected range that are btw 5 to 50 and (-5) to (-50)?



"Zack Barresse" wrote:

Hi there Aleks,

You can use the following ...

=SUMPRODUCT(--(ABS(U2:U2000)50))

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board,
as
to benefit others.




"Aleks" wrote in message
...
I am trying to count cells in selected range that are above 50 and
below -50.
How can I do this without creating another row with absolute values. I
tried this but it doesn't work

=countif(abs(u2:u2000),"50").