Thread
:
Countif with dynamic criteria
View Single Post
#
1
FinChase
Posts: n/a
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.
Reply With Quote