Thread
:
Using countif with 2 conditions
View Single Post
#
2
Don Guillett
Posts: n/a
try something like this
=sumproduct((a2:a200=913)*(c2:c200<=999))
--
Don Guillett
SalesAid Software
"Cheryl W" <Cheryl
wrote in message
...
I want to count the number of times the data in column a =913 AND the
value
in column c is <=999. I only want to count rows in which both conditions
are
true. Countif only allows for one condition so how do I accomplish this?
Reply With Quote