JOIN and SUM

I have this situation

ROW 1: BUS 101 | [need the formula]
ROW 2: BUS 101 |  $1,000
ROW 3: BUS 101 |  $1,000

In the cell where I need a formula, I want to have Smarsheet look at rows (always below, but it may be 2, 3 or even 4 rows) that have the same code (BUS 101) in one column and add the amounts.

So, the [need the formula] would show $2,000.

ROW 1: BUS 101 | [need the formula]
ROW 2: BUS 101 |  $1,000
ROW 3: BUS 101 |  $1,000
ROW 4: BUS 101 |  $2,000

In this example, the [need the formula] would show $4,000.

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @aschneiderheinze74206

Hope you are fine, please try the following formula:

=SUMIFS(Sum:Sum, Code:Code, Code@row)

the following screenshot shows the result:

Art Schneiderheinze

What if BUS 101 isn't always in the first column?

BUS 101 | (need formula)

BUS 101 | $1,000

BUS 101 | $1,500

CAR 243 | $4,500

CAR 243 | $1,500

CAR 243 | $3,000

ECO 433 | $,5000

ECO 433 | $5,000

Bassam Khalil

@aschneiderheinze74206

Please add a copy of your sheet after removing any sensitive data and show me what you need exactly.

Also you can do it by creating a report and group it by the code and use the sum by cost in this report.

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.