ExcelBanter - sumif

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumif (https://www.excelbanter.com/excel-discussion-misc-queries/55485-sumif.html)

Sumif

sumif

I have three coloumn A=PO; B=Part # and C=quantity. And I would like to sum
the quantity for a part # of a particular PO. How should I make a sumif
function? Also could "IF" function nested into a sumif function.

Thank you.

Regards
Carmen

Jerry W. Lewis

sumif

=SUMPRODUCT((A1:A20=PO)*(B1:B20=PN),C1:C20)

Jerry

Sumif wrote:

I have three coloumn A=PO; B=Part # and C=quantity. And I would like to sum
the quantity for a part # of a particular PO. How should I make a sumif
function? Also could "IF" function nested into a sumif function.

Thank you.

Regards
Carmen

All times are GMT +1. The time now is 08:55 AM.