Help with sumifs and date field

I have a formula that was correctly returning the sumifs of a column (gross) based on the deposit date in 2022 if in the current calendar month. Beginning this year, it is no longer returning data from this month. Not sure what is wrong. Here is data.

Formula

=SUMIFS({Gross Commission 1}, {Deposit Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Agent 1}, [Agent Name]@row)

Any help appreciated.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you getting the wrong number, or an error message?

Ron Anderson

Sorry. I meant to take this down. I forgot that I had 2022 numbers and 2023 numbers in the referenced table so it was working correctly based on the data I added. To get it right with both years, I need to add a year filter too. My bad.

Thanks for your time.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.