SUMIFS and Contains

Kia Marie Velasco

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!

Paul Newcome

Try this one instead...

=SUMIF([Payment Amount]2:[Payment Amount]3, CONTAINS("FY20", @cell), [Payment Amount]2:[Payment Amount]3)

Kia Marie Velasco

Thanks, Paul. That returned a 0 as well, but this one seems to work finally:

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

Paul Newcome

Your first formula references a different column and only two rows for each range. That may be why it returned zero after updating the @cell reference.