# Formula to sum values based on multiple cells.

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.

Tags:

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

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

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

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

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!