Help with creating formula

Hello - I need some help with a formula.... Hopefully someone from this community can provide some guidance.

I have the following sheet with multiple columns. I am trying to sum up the total "Approved Change Order Amount" by "Category".

For instance, rows #1 and # 6 have the same category (Regulatory Submissions). Based on the "Approved Change Order Amount" column, the sum for both rows should be $23,000.

I plan to add this formula in the Summary Sheet (instead of adding another column with this formula).

Thank you!

Find more posts tagged with

Accepted answers

Mike TV

@Vane

If you only want to add those if the Status is Approved, you'd use this formula:

=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")

All comments

Mike TV

@Vane

If you only want to add those if the Status is Approved, you'd use this formula:

=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")

Vane

@Mike TV

Thank you!!! This formula worked, and you saved me a lot of time :)

Vane

@Mike TV Do you happen to know how to cross reference a sheet by using this formula?

Essentially, I plan to create another sheet with two columns (category name and formula), as seen below:

Then, I want to extract the data from another sheet titled "Change Order Log". The original formula works well if I use it in the Change Order Log sheet (since this is where I have my data). But how do I transfer the final result of this formula to this new sheet?

Original formula: =SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")

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.