SUMIFS returns a $0 (s/b an amount) once there are Oct 2022 & 2023 entries in a date range

Aloha,

I have a SUMIFS formula that works until I have Oct 2022 and Oct 2023 entries in the date range. Then Oct 2023 returns a $0 when it should return an amount. I have tried reversing the month and year in order in the formula and it still returns a $0, any help would be appreciated.

=SUMIFS(Price33:Price174, [Expected Closing Date]33:[Expected Closing Date]174, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2023))

Find more posts tagged with

Accepted answers

All comments

Chelsea Smitchger

A COUNTIFS formula for the same range and month/year would also be helpful. Thanks

Paul Newcome

It looks like the formula you posted is looking for September 2023 and not October.

Chelsea Smitchger

Thank, I have figured out the issues.

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.