Try this:

=SUMPRODUCT((A2:A4="Y")*(B2:B4="Q")*(C1:E1="O"),C2 :E4)



"Steven" wrote:

M N O
X P 1 4 7
Y Q 2 5 8
Y P 3 6 9

These are Cells A1 to E4

How do I return a lookup that Y, Q, O = 8

Thank you


Steven