Nested Countif

  • Thread starter Thread starter poloxstar
  • Start date Start date
P

poloxstar

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
 
Hi
try
=SUMPRODUCT(--(A1:A10>65),--(B1:B10="cable"))
this will return zero
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iiyama 144hz - soon after power outage booted low refresh 2
Nesting IF or IF 2
Excel Need Countifs Formula Help 0
Calculation of Overlap Outage Hours 17
Are all ISP's poor? 7
Return a list of Occurrences 1
Determining availability time 1
Need help with combo boxes in messages! 0

Back
Top