Any insight offered will be very appreicated.

I'm trying to use the following formula:

=IF(AND(D8:D229="Labor
CAP",C8:C229="Complete"),G8:G229,SUMPRODUCT(--(D8:D229="Labor
CAP"),--(C8:C229<"Not Ordered"),E8:E229))

The goal is this: If any cells in range D8:D229 = Labor CAP and any cells
in range C8:C229 = Complete, sum corresponding cells in range G8:G229, if
not, find cells in range D8:D29 = Labor CAP and cells in range C8:C229 that
are not equal to Not Ordered, and sum corresponding cells in range E8:E229.

Thank you.