SUMIFS referencing a date column

Hoping someone can help with what I'm sure is a painfully simple fix.

I'm getting INVALID COLUMN VALUE with the following formula. I've researched this error and it doesn't seem like the column type should be anything except text/number.

=SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], IFERROR(MONTH(@cell) = 1, ""))

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Frank Falco

Give this a try

=IFERROR(SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], MONTH(@cell) = 1), "")

What is the type of the column this is in?

Cara Parfitt

Hi Frank,

Thanks so much! The IFERROR at the beginning did the trick.

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.