Formula to sum values based on multiple cells.

Brian Hassett

Hi All,

I am managing a material tracking sheet and I need a little bit of help with the following:

I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info in 3 other columns.

So the formula will find all the rows with where the PO No. cells match and the Material Description cells match and 'Qty In/Out' = Out It will then sum the 'Qty'

The PO No. value will be different for each order. The same PO No. can cover multiple Material Types.

The Material Description is from a drop down List

I can currently Sum based on Material Description but cannot work out how to incorporate the PO No.

Any help would be much appreciated.

Thanks.

Material Tracking Example.JPG

Paul Newcome

You will need a SUMIFS and are missing a comma.

=SUMIFS(QTY:QTY, [PO NO.]:[PO No.], [PO No.]@row, [In/Out]:[In/Out], "Out", [Material description]:[Material description], [Material description]@row)

Hollie Green

@Paul Newcome Thank you for the correction! I can't seem to type correctly the past couple of days

Paul Newcome

@Hollie Green No worries. I have days like that too.

Hollie Green

=Sumif(QTY:QTY,[PO NO.]:[PO No.],[PO No.]@row,[In/Out]:[In/Out],"Out"[Material description]:[Material description],[Material description]@row)

Brian Hassett

Thanks for your reply @Hollie Green but unfortunately I am getting #UNPARSEABLE when I run that formula.

Paul Newcome

You will need a SUMIFS and are missing a comma.

=SUMIFS(QTY:QTY, [PO NO.]:[PO No.], [PO No.]@row, [In/Out]:[In/Out], "Out", [Material description]:[Material description], [Material description]@row)

Hollie Green

@Paul Newcome Thank you for the correction! I can't seem to type correctly the past couple of days

Paul Newcome

@Hollie Green No worries. I have days like that too.

Brian Hassett

@Hollie Green and @Paul Newcome Thank you very much. That saved me a lot of head scratching.

Paul Newcome

Happy to help. 👍️