How would up update this existing SUMIFS formula to add an additional criteria?

I have a current formula that but we have realized that there is one Team who's numbers are skewing the results and would like to have there totals excluded.

=SUMIF([Cast Type]:[Cast Type], "Vendor", Estimate:Estimate) + SUMIF([Cast Type]:[Cast Type], "Contractor-Offshore", Estimate:Estimate)

The Additional Column is called "Team" and we would want to exclude any values that correlate to TEAM="TPM", leaving the values for the other teams "Team1", "Team2" for placeholders.

Find more posts tagged with

Formulas

Accepted answers

All comments

Michelle Choate 2

=SUMIFS(Estimate:Estimate, [Cast Type]:[Cast Type], OR(@cell = "Vendor", @cell = "Contractor-Offshore"), Team:Team, <>"TPM")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.