IF statement with nested SUMPRODUCT?
=if(sumproduct(--(D8:D229="Labor
CAP")*(C8:c229="Complete"),(G8:G229))=0,sumproduct (--(c8:c229<"Not
Ordered"),(E8:E229)),sumproduct(--(D8:D229="Labor
CAP")*(C8:c229="Complete"),(G8:G229)))
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Bazael" escreveu:
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.
|