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!

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.