Using countif with 2 conditions

[Guest]

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?

 

[Don Guillett]

try something like this
=sumproduct((a2:a200=913)*(c2:c200<=999))

 

[Paul Sheppard]

I want to count the number of times the data in column a =913 AND th
value
in column c is <=999. I only want to count rows in which bot
conditions are
true. Countif only allows for one condition so how do I accomplis
this?

Hi Cheryl

Try this > type this formula =SUM((A1:A15=913)*(C1:C15=999)) into an
blank cell and enter as an arrayby CTRL/Shift/Enter at the same time

Change the rabges A1:A15 and C1:C15 to suit your dat