Sumif a set of corresponding values

R

raphiel2063

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif a corresponding value is not equal to zero or blank 1
Multiple Criteria, Count If, Sum Product to get count across range 5
sumif 1
Sumif across a table 1
vlookup 3 sheets 1
VLOOKUP results in problems in comparing 3
COUNTIF? SUMIF? SUMPRODUCT? IF? 2
Sum of different value in different worksheet & cell number 2

Top