Countif with 2 conditions

[poloxstar]

Hi,
I am need of assistance
I am stuck with a formula

ClearCode Resolve Time
9999 60
8888 47
9999 55

I want to know how man ClearCode is equal to 9999 and Resolve Time i
greater than 59. It is in 2 different columns

I am trying to use the countif function but I am totally stuck. I
there an excel Guru around that could help?
Thank

 

[Ron de Bruin]

Try this

=SUMPRODUCT((C2:C10=999)*(D210>59))

 

[poloxstar]

Thanks,
Regards Ron de Bruin

You are definetly a Guru

 

[poloxstar]

Thanks,
Regards Ron de Bruin

You are definetly a Guru