How to incorporate an "is not checked" into a formula

Hi,

This formula is working great until I try and add in the section in which I want to only include revenue if the "Multi-year contract" column is unchecked. Help!

=SUMIFS([Contract Sales]:[Contract Sales], [Renewal Date]:[Renewal Date], >DATE(2024, 6, 29), [Renewal Date]:[Renewal Date], <DATE(2024, 10, 1), IF([Multi-year contract]1 = 0))

This part is causing the problem: IF([Multi-year contract]1 = 0))

Thanks!

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Tricia Banks

I think you are looking for this:

SUMIFS([Contract Sales]:[Contract Sales], [Renewal Date]:[Renewal Date], >DATE(2024, 6, 29), [Renewal Date]:[Renewal Date], <DATE(2024, 10, 1), [Multi-year contract]:[Multi-year contract, 0)

However if you are looking for the SUMIFS to only happen specifically when row 1 is unchecked, then the formula is

=IF([Multi-year contract]1 = 0, SUMIFS([Contract Sales]:[Contracts Sales], [Renewal Date]:[Renewal Date], >DATE(2024, 6, 29), [Renewal Date]:[Renewal Date], <DATE(2024, 10, 1))

Will either of these formulas work for you?

Kelly

All comments

Kelly Moore

Hey @Tricia Banks

I think you are looking for this:

SUMIFS([Contract Sales]:[Contract Sales], [Renewal Date]:[Renewal Date], >DATE(2024, 6, 29), [Renewal Date]:[Renewal Date], <DATE(2024, 10, 1), [Multi-year contract]:[Multi-year contract, 0)

However if you are looking for the SUMIFS to only happen specifically when row 1 is unchecked, then the formula is

=IF([Multi-year contract]1 = 0, SUMIFS([Contract Sales]:[Contracts Sales], [Renewal Date]:[Renewal Date], >DATE(2024, 6, 29), [Renewal Date]:[Renewal Date], <DATE(2024, 10, 1))

Will either of these formulas work for you?

Kelly

Tricia Banks

The second one worked. Thanks so much!

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.