=SUMPRODUCT(--(K20:K632="450300"),--(N20:N632={"SM1-Assy","SM2-Assy"}),O20:O
632)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Craig Koon" <Craig wrote in message
...
Can anyone please review and correct formula to work for me. Unable to get
it
right. Too stumped to continue. Ready to pull last hairs out....

=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,)



Thanks