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!
Answers
-
Try this one instead...
=SUMIF([Payment Amount]2:[Payment Amount]3, CONTAINS("FY20", @cell), [Payment Amount]2:[Payment Amount]3)
-
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)
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!