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

Deleting all but one occurrence of text from a selection 0
Adding a big matrix in Word 2013 5
Define a Range based on Cell Values 2
Multiple Criteria, Count If, Sum Product to get count across range 5
Countif a corresponding value is not equal to zero or blank 1
Sumif across a table 2
sumif 1
Compute Additional Hours Needed Using "if" or "lookup" 1

Top