How to sum a column by only pulling cells based on separate formula

Hello - can someone help with the following formula(s)?

I want to include the cells included from this formula: =COUNTIFS([Card_StartDate]:[Card_StartDate], <=DATE(2021, 12, 31), LaneTitle:LaneTitle, NOT(CONTAINS("Parent", @cell)))

...And sum the totals from this column: Card_Size:Card_Size

The LaneTitle column is Text. The Card_StartDate column is Date. The Card_Size column is Text.

Thank you for any insights you can provide!

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Brooke Clem ,

Try:

=SUMIFS([Card_size]:[card_size], [Card_StartDate]:[Card_StartDate], <=DATE(2021, 12, 31), LaneTitle:LaneTitle, NOT(CONTAINS("Parent", @cell)))

Work?

Mark

All comments

Mark Cronk

Hi @Brooke Clem ,

Try:

=SUMIFS([Card_size]:[card_size], [Card_StartDate]:[Card_StartDate], <=DATE(2021, 12, 31), LaneTitle:LaneTitle, NOT(CONTAINS("Parent", @cell)))

Work?

Mark

Brooke Clem

by george you"ve got it! thank you!

Mark Cronk

Happy yo help. Thank you for contributing to the Communuty.

Mark

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.