Quote:
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. |
THanks for responding & Glad that you found the countifs. Your suggestion didn't work so here are the answers to your questions:
The ampersand was added by the formula helper and the coding 1,0,0, is iin the format H,M,S.
Actually I am trying to get the number of entries on a specific day between specific housr, in this case Midnight and 1 AM.