Nested Countif
 

Can anybody help.
I am looking to create a conditions that looks at 2 different columns?

Time Outage
65 cable
56 phone


count how many cable outage that is is greater that 65

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

Nested Countif
 

Hi
try
=SUMPRODUCT(--(A1:A1065),--(B1:B10="cable"))
this will return zero

--
Regards
Frank Kabel
Frankfurt, Germany

"poloxstar " schrieb im
Newsbeitrag ...
Can anybody help.
I am looking to create a conditions that looks at 2 different
columns?

Time Outage
65 cable
56 phone


count how many cable outage that is is greater that 65?


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