View Single Post
  #2   Report Post  
Elkar
 
Posts: n/a
Default absolute function - range

Try this:

=countif(u2:u2000,"50")+countif(u2:u2000,"<-50")


"Aleks" wrote:

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").