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.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!