Creating a formula for sub-total based on SOW#

Hello, I need some assistance with a formula.

I have the following sheet with an 'Original SOW#' & 'Approved Change Order Amount' columns. I would like to sum up the Approved Change order Amount by Original SOW# AND bring this subtotal to a different sheet.

Example, for SOW# 012, the sub-total should be $117,000.

Then, I would like to bring this sub-total to the following sheet under column "Change Order Value" for SOW#012 (or the first row).

Any advice? Thank you!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

What is your existing formula that is throwing an error? That particular error comes from having a {cross sheet reference} typed in but not actually set up properly.

Vane

@Paul Newcome Correct. I was originally using a cross sheet reference. In the cross sheet, I had the following formula: =SUMIFS({COs}, {Categories}, HAS(@cell, "Regulatory Submissions"))

However, in the above example, I was doing it by 'Category' and that is why I wrote 'Regulatory Submissions'.

Now, the plan is to do it by 'Original SOW #'.

Paul Newcome

Ok. SO when you updated the formula, did you create a new cross sheet reference for the SOW #?

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.