Formula to calculate Monthly Total

I am trying to get the Total Amount for January only, but I keep getting 0.

My sheet has dates up to Dec, and I created a helper column to filter months, but I can't get it to work. I used this formula:

=SUMIFS([Total Amount]1:[Total Amount]17, Date1:Date17, IFERROR(MONTH(@cell), 0) = [Helper Month Column]@row)

Any idea what I am doing wrong? screenshot attached. Thanks

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Shile

The MONTH Function returns months as numerical values (ex. January = 1, not "January"). This means that if you're looking to see if the Date cell has January, you'll want to look for 1.

MONTH(@cell) = 1

Try this instead:

=SUMIFS([Total Amount]1:[Total Amount]17, Date1:Date17, IFERROR(MONTH(@cell), 0) = 1)

You could actually delete out your helper column in this instance! Let me know if that works and makes sense.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Shile

The MONTH Function returns months as numerical values (ex. January = 1, not "January"). This means that if you're looking to see if the Date cell has January, you'll want to look for 1.

MONTH(@cell) = 1

Try this instead:

=SUMIFS([Total Amount]1:[Total Amount]17, Date1:Date17, IFERROR(MONTH(@cell), 0) = 1)

You could actually delete out your helper column in this instance! Let me know if that works and makes sense.

Cheers,

Genevieve

Shile

Thanks for helping.

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.