ExcelBanter - Sumif a set of corresponding values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumif a set of corresponding values (https://www.excelbanter.com/excel-worksheet-functions/182554-sumif-set-corresponding-values.html)

raphiel2063

Sumif a set of corresponding values

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?

Gary''s Student

Sumif a set of corresponding values

=SUMPRODUCT(--(A1:A5="apple"),--(B1:B5="Y"),C1:C5)

--
Gary''s Student - gsnu200777

"raphiel2063" wrote:

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?

All times are GMT +1. The time now is 07:21 AM.