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

Karen Hansard

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.

Thanks

Amit Wadhwani

Hi @Karen Hansard

You can create another helper column which calculates only sum and in the Sum Column you can implement the formula.

Add this formula in the helper column - =Amount@row * Freq@row

And add the formula In the Sum column - =SUMIF(Name:Name, Name@row, Helper:Helper)

I hope this solves your issue.

 

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/