pick from list
 

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

pick from list
 

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


Replace @mailinator.com with @tiscali.co.uk


"ekkeindoha" wrote in message
...
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