View Single Post
  #1   Report Post  
Erin
 
Posts: n/a
Default Counting values between 70 and 140

I'm creating a worksheet that requires a function that counts the number of
values between 70 and 140.

I've tried =COUNTIF(U60:AM90,"70")-COUNTIF(U60:AM90,"<140") however this
duplicate counts the over 70 group.

Any help would be appreciated!
Erin