SUMIFS and CONTAINS Formula

Nate420

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

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...)

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...)