pick from list

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top