Creating a formula for sub-total based on SOW#

Hello, I need some assistance with a formula.

I have the following sheet with an 'Original SOW#' & 'Approved Change Order Amount' columns. I would like to sum up the Approved Change order Amount by Original SOW# AND bring this subtotal to a different sheet.

Example, for SOW# 012, the sub-total should be $117,000.

Then, I would like to bring this sub-total to the following sheet under column "Change Order Value" for SOW#012 (or the first row).

Any advice? Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!