View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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?