I want to sum up a column of data if the value of two columns is what I want.

E.g.
Y/N Qty
Apple N 1
Banana Y 0
Apple Y 0
Apple Y 6
Banana N 3

I would like to be able to look up apples and Y and sum up the corresponding
column. In the above example the answer would be 6. If it was Bananas and Y
then it would be 0.

Anybody able to help?