Originally Posted by BobBridges

I never even knew the COUNTIFS function existed; I sat there wondering why you were trying to use multiple conditions in a COUNTIF function, at first. So my questions may not be very worthwhile. Still, there are two things about your second COUNTIFS call that I don't understand (and I suspect that Excel doesn't either):

1) x=<1,0,0. What does this mean?
2) Why is there an ampersand at the beginning of the string?

I surmise you're trying to add a condition that the time cell must contain a positive number less than 24 hours. If so, I would have tried it this way:

=COUNTIFS(HFC!F:F,"Outage",HFC!B:B,A311,HFC!D,"> =0",HFC!D,"<1")

Could be I'm still missing something important about what can be done with these conditions.