SUMIFS and Contains


I'm trying to use SUMIF with CONTAINS using:

=SUMIF([Payment Amount]2:[Payment Amount]3, CONTAINS("FY20", [Date Paid QFY]2:[Date Paid QFY]3), [Payment Amount]2:[Payment Amount]3)

But I'm getting a 0 result.

Note that Date Paid QFY is a formulated column that returns for example, Q1 FY20 based on another date column.

Please advise on what needs to be adjusted. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!