Thread
:
Countif with dynamic criteria
View Single Post
#
6
Don Guillett
Posts: n/a
glad to help
--
Don Guillett
SalesAid Software
"FinChase" wrote in message
...
Thanks to everyone who replied. It all helped.
"Don Guillett" wrote:
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