View Single Post
  #1   Report Post  
FinChase
 
Posts: n/a
Default Countif with dynamic criteria

I am trying to write a countif statement where the criteria is a range of
numbers from 30 - 39. This is what I've written:

=countif(e2:e1956,"29<40")

Right now it is counting everything over 29.