Or function within a countifs statement

[transitsolutions]

I almost have this formula where i need it, but for some reason i am getting caught up with this OR function.

This was my original Formula: =COUNTIFS('Data Entry'!G2:G999, "DVR (bus)",'Data Entry'!B2:B999,"<="&'System Uptimes'!A4,'Data Entry'!C2:C999,">="&'System Uptimes'!A4)

This is what i am trying with the OR:
=COUNTIFS('Data Entry'!G2:G999, "DVR (bus)",'Data Entry'!B2:B999,"<="&'System Uptimes'!A4,'Data Entry'!C2:C999,OR(">="&'System Uptimes'!A4,ISBLANK('Data Entry'!C2:C999)))

I had some test values in my "Data Entry" sheet and my formula was evaluating to 2, which was almost right, but i also needed this OR and ISBLANK function to check for empty cells. Whenever i use this formula with the OR in it, my output goes to 0. With the examples i have in my Data Entry Sheet the OR should be adding another count, so i should evaluate to 3. It seems to me like the OR is acting like an AND in this case.

Thanks in advance for the help.

[Ace_XL]

Try

=SUMPRODUCT(('Data Entry'!G2:G999="DVR (bus)")*('Data Entry'!B2:B999<='System Uptimes'!A4)*(('Data Entry'!C2:C999>='System Uptimes'!A4)+(ISBLANK('Data Entry'!C2:C999))))

[rcm]

as far as I know contifs() clauses are ANDS,

split the countifs adding them together,

Please Login or Register  to view this content.

[transitsolutions]

The SUMPRODUCT function did the trick. thanks a lot!