Using Sumifs and Month referencing another sheet

Hello!

I am trying to sum the values occuring in a particular month referencing another sheet. Here's my formula:

=SUMIFS({Summary Roll-Up - Machine Accepted}, {Summary Roll-Up - Machine Accepted}, >0, {Summary Roll-Up - Delivery End}, MONTH(@cell) = 1)

The first part of the formula is working correctly, but when I add the date part, I get an #Incorrect Argument error.

Appreciate any help anyone can provide.

Thank you,

Angela Cisneros

Find more posts tagged with

Formulas

Accepted answers

David Tutwiler

Are you using the Date column type in the range {Summary Roll-up - Delivery End}?

All comments

David Tutwiler

Are you using the Date column type in the range {Summary Roll-up - Delivery End}?

Angela Cisneros

Wow! That fixed it. Thanks for the tip!

David Tutwiler

No problem. Glad it's working.

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.