Thread
:
Countif with dynamic criteria
View Single Post
#
3
Don Guillett
Posts: n/a
try
=sumproduct((e2:e195629)*(e2:31956<40))
--
Don Guillett
SalesAid Software
"FinChase" wrote in message
...
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