SUMIFS: IFERROR Function to Ignore Empty Date Cells Not Working

Hello,

I need to add an IFERROR function to the below formula, but cannot figure out what to input to make it work. I keep getting #INVALID DATA TYPE, #UNPARSEABLE, and #INCORRECT ARGUMENT SET errors.

The goal is to return the total Amount for a particular Team (Retail in this instance) by week for only rows that have an Award Date entered.

=SUMIFS(Amount:Amount, Team:Team, "Retail", [Award Date]:[Award Date], WEEKNUMBER(@cell) = 8)

This is just one of my many failed attempts:

=SUMIFS(Amount:Amount, Team:Team, "Retail", [Award Date]:[Award Date], WEEKNUMBER(@cell) = 8, IFERROR(WEEKNUMBER(@cell) = 0))

Any help would be greatly appreciated!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Miranda F.

You're building this in the right direction! Date functions don't like it when there are blank cells or cells with text in a referenced range. The IFERROR would go around the WEEKNUMBER function directly, try this:

=SUMIFS(Amount:Amount, Team:Team, "Retail", [Award Date]:[Award Date], IFERROR(WEEKNUMBER(@cell), "") = 8)

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Miranda F.

=SUMIFS(Amount:Amount, Team:Team, "Retail", [Award Date]:[Award Date], IFERROR(WEEKNUMBER(@cell), "") = 8)

Cheers,

Genevieve

Miranda F.

And just like magic, it works! Thank you, thank you!!

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.