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

Hi Craig
You haven't allowed for a FALSE condition
Try this:
=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,"nothing")

and use Ctrl Shift Enter to make it an array

HTH
Michael M

"Craig Koon" wrote:

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

=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

It would be impossible for this formula to ever evaluate to TRUE, since N20
would have to contain both "SM1-Assy" AND "SM2-Assy". A cell can only
contain one value.

Perhaps you want to use an OR condition for N20?

See if this is what you're looking for:

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

HTH,
Elkar


"Craig Koon" wrote:

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