Countif with 2 conditions
 

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

--
Message posted from http://www.ExcelForum.com

Countif with 2 conditions
 

Try this

=SUMPRODUCT((C2:C10=999)*(D2:D1059))

--
Regards Ron de Bruin
http://www.rondebruin.nl


"poloxstar " wrote in message ...
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 is
greater than 59. It is in 2 different columns

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


---
Message posted from http://www.ExcelForum.com/

Countif with 2 conditions
 

Thanks,
Regards Ron de Bruin

You are definetly a Guru

--
Message posted from http://www.ExcelForum.com

Countif with 2 conditions
 

Thanks,
Regards Ron de Bruin

You are definetly a Guru

--
Message posted from http://www.ExcelForum.com