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.

Thanks

Find more posts tagged with

Accepted answers

All comments

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/

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.