Incorrect Argument Set

It seems I have problems with the SUMIFS formula. Tried replicating one that works and that was a no go.

=SUMIFS({031-Purchase Order - Completed}, "Completed", {031-Purchase Order - Amount}, {031-Purchase Order - Year}, 2025)

I want to sum together completed invoices by year.

Thank you in advance.

Ali

Find more posts tagged with

Accepted answers

John Stonebraker

Looks like the syntax is wrong - the first argument should be the range to sum, 2nd and 3rd should be the first range to test and the criteria to test (respectively). 4th and 5th should be the next test range and criteria respectively. "Completed" in the 2nd position is a criteria, not a range, and that's the error you're seeing. You might need 2025 to be in quotes.

All comments

John Stonebraker

AliT

Thank you for your reply, but I am still confused.

Are you saying the AMOUT should be first, the COMPLETED come after and end with the YEAR?

AliT

@John Stonebraker - Thank you. It took me some time, but that did work.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.