Unparsable Error for formula

AliT

I need to sum data in one column based on the month and year.

=SUMIFS({011-AP Archive Computed Count}, {011-AP Archive Month}, 12, {011-AP Archive Year},2025))

I did the same formula for COUNTIFS, and it worked beautifully.

=COUNTIFS({011-AP Archive Month}, 12, {011-AP Archive Year}, (2025))

Any help will be appreciated.

Find more posts tagged with

Accepted answers

Paul Newcome

Remove one of the closing parenthesis from the end (you also don't need the extra set of parenthesis around 2025 in the COUNTIFS).

Paul Newcome

You are missing the {Range To Sum} (and the "S" to turn it into a SUMIFS function). Assuming it is the same range as the first range/criteria set, it would look like this:

=SUMIFS({011-AP Archive -# of Days to Complete}, {011-AP Archive -# of Days to Complete}, <30, {011-AP Archive Year}, 2025)

All comments

Paul Newcome

Remove one of the closing parenthesis from the end (you also don't need the extra set of parenthesis around 2025 in the COUNTIFS).

AliT

OH my Goodness!! Thank you!!

That worked!!

AliT

Hi Paul,

Wondering if you can help me out one more time. It seems I have issues with the SUMIFS formula

=SUMIF({011-AP Archive -# of Days to Complete}, <30, {011-AP Archive Year}, 2025)

I want to sum the days for the year 2025. I know what the outcome should be because I have filtered my data.

Thank you in advance.

Paul Newcome

You are missing the {Range To Sum} (and the "S" to turn it into a SUMIFS function). Assuming it is the same range as the first range/criteria set, it would look like this:

=SUMIFS({011-AP Archive -# of Days to Complete}, {011-AP Archive -# of Days to Complete}, <30, {011-AP Archive Year}, 2025)

AliT

That did it!! Thank you again.

Paul Newcome

Happy to help. 👍️

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.