How to Sum Values in Multiple Rows in a Table and place the Sum in another column.


In this example here, I would like to sum the (Amount * Freq) for each occurrence of a Name and place the total sum in the SUM column for each row with that Name. How can I accomplish this?

(10 * 1) + (5 * 2) + (54 * 1) = 74.

Seems very simplistic but can't seem to get the formula close at all.

Ultimately I want to reference the Sum in another sheet via cell link without having to do cross-sheet references.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!