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
Check out the Formula Handbook template!