SUMIFS with multiple AND and OR criteria. How?

[mastertonn]

I would like to create a SUMIFS formula with the following criteria:
Criteria A AND Criteria B AND Criteria C AND Criteria D OR Criteria E

The sum range is A2:A10000.
E1 is a header row. The header is "TIME".
Criteria D is the target cell of the range E2:E10000 is empty.
Criteria E is the target cell of the range E2:E10000 is greater than cell G2 (9:00 AM).

Currently what I think I could do is:
=SUMIFS(Criteria A AND Criteria B AND Criteria C AND Criteria D)+SUMIFS(Criteria A AND Criteria B AND Criteria C AND Criteria E)

There is a lot of repetition (bold part). I wonder if there is any way to simplify it.
Thank you.

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jason.b75]

No workbook needed to answer that one

try

=SUM(SUMIFS(A2:A10000, range A, criteria A, range B, criteria B, range C, criteria C, E2:E10000, {"=", ">=09:00:00"}))

[mastertonn]

Thank you. Another issue. I cannot use any formula or reference in the array, can I?

For example, none of them works:

Please Login or Register  to view this content.

=SUM(SUMIFS(A2:A10000, range A, criteria A, range B, criteria B, range C, criteria C, E2:E10000, {"=", ">=09:00:00"}))

[jason.b75]

Not tried this method, but no reason it shouldn't work

=SUM(SUMIFS(A2:A10000, range A, criteria A, range B, criteria B, range C, criteria C, E2:E10000,CHOOSE({1,2},"=",">="&MOD(NOW(),1))))

[mastertonn]

Thank you jason.b75, but it doesn't work. It returns 0.

[XOR LX]

Try replacing the initial SUM with SUMPRODUCT in the formula from post #5.

Regards