Total Amount of Rejections Created Last Week

Help!!!! I can't figure out where the problem is with my formula. I am trying to write a formula to calculate the total $ amount of rejections from last week. This is what I have. It comes up with an Incorrect Arugument.

@Paul Newcome can you help?, please...... 😀

=IF(WEEKNUMBER(TODAY()) = 1, SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = 52, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1), SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

Find more posts tagged with

Accepted answers

Paul Newcome

It is with your SUMIFS statements.

You have:

=SUMIFS(range, criteria, range, criteria)

You SHOULD have:

=SUMIFS(range to sum, range, criteria, range, criteria)

All comments

Paul Newcome

It is with your SUMIFS statements.

You have:

=SUMIFS(range, criteria, range, criteria)

You SHOULD have:

=SUMIFS(range to sum, range, criteria, range, criteria)

Pam Ferguson

@Paul Newcome OMG you are wonderful, I was sitting here racking my brain. All fixed! You did it again! It's Friday, I need to give my brain a rest! Thank you again!!!

Paul Newcome

Happy to help! 👍️

Enjoy your weekend!

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.