# 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

Tags:

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

Regards,

Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

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

Regards,

Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!