SUMIFS and CONTAINS Formula

I am try to sum the total weight of a column on a different sheet if the name contains certain text and will be released on a certain date. I am using the below formula but getting #INCORRECT

=SUMIFS({Estimated Weights Range EST Weight}, CONTAINS("C-Vibez", {Estimated Weights Strain Name}), {Estimated Weights Est Release Date}, IFERROR(MONTH(@cell), 0) = 2, {Estimated Weights Est Release Date}, IFERROR(YEAR(@cell), 0) = 2023) / 1000

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

I think you've got a SUMIFS syntax issue with the CONTAINS function. Try this:

=SUMIFS({Estimated Weights Range EST Weight}, {Estimated Weights Strain Name}, CONTAINS("C-Vibez", @cell), {Estimated Weights Est Release Date}, IFERROR(MONTH(@cell), 0) = 2, {Estimated Weights Est Release Date}, IFERROR(YEAR(@cell), 0) = 2023) / 1000

This satisfies the SUMIFS syntax, which is =SUMIFS(Range to Sum, Criteria Range 1, Criteria 1, Criteria Range 2, Criteria 2...)

All comments

Jeff Reisman

I think you've got a SUMIFS syntax issue with the CONTAINS function. Try this:

This satisfies the SUMIFS syntax, which is =SUMIFS(Range to Sum, Criteria Range 1, Criteria 1, Criteria Range 2, Criteria 2...)

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.