pick from list

[Guest]

Good day,

A B C D
1 AA AC
2 AB AA
3 X AC AD
4 X AD

What I need to do are - if AC in column C are marked with A "X" in column B,
it must give me the value in column A

 

[Sandy Mann]

Try:

=SUMPRODUCT((C1:C14="AC")*(B1:B14="X")*A1:A14)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk