SUMIF and NOT Functions

I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column.

=SUMIF({Region}, "Philadelphia", {Contracted})

=SUMIF({Region}, "Philadelphia", {07/09/25})

=SUMIF({Region}, "Philadelphia", {Difference})

Thank you

Find more posts tagged with

Formulas

Accepted answers

Amy Arnold

@Nic Larsen When I update my formula to what is below, I get #UNPARSEABLE.

=SUMIF(({Region}, "Philadelphia", {Contracted}, {CCC}, NOT(@cell = 1))

All comments

Nic Larsen

You should just be able to add this to the end of your formulas:

{Range CCC}, NOT(@cell = 1)

Amy Arnold

@Nic Larsen When I update my formula to what is below, I get #UNPARSEABLE.

=SUMIF(({Region}, "Philadelphia", {Contracted}, {CCC}, NOT(@cell = 1))

Nic Larsen

Sorry we need to switch to a SUMIFS and rearrange:

=SUMIFS({Contracted}, {Region}, "Philadelphia", {CCC}, NOT(@cell = 1))

Amy Arnold

@Nic Larsen That works perfectly. Thank you!

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.