Sumifs forumla with unparseable error. What am I doing wrong?

I am using a sumifs formula to sum a column from another sheet. My formula is

=SUMIFS({CRA MV Report Metrics Range 5}}, [CRA Name]@row, {CRA MV Report Metrics Range 2}, [Visit Type]@row, {CRA MV Report Metrics Range 4}, [Visit Type Description]@row, {CRA MV Report Metrics Range 3})

Is there something wrong with my formula?

Find more posts tagged with

Accepted answers

Michelle B

@Paul Newcome

Range 5 is what I am summing. However, I do have the criteria and criteria range backwards. I have fixed the formula and it looks to be working.

=SUMIFS({CRA MV Report Metrics Range 5}, {CRA MV Report Metrics Range 2}, [CRA Name]@row,{CRA MV Report Metrics Range 4}, [Visit Type]@row, {CRA MV Report Metrics Range 3}, [Visit Type Description]@row)

Thank you @Paul Newcome and @ker9 for the fast responses!!

All comments

ker9

Hi @Michelle B

It may be due to a double }} before the first comma:

=SUMIFS({CRA MV Report Metrics Range 5}},

Hope that helps!

Michelle B

@ker9 Thank you!! I have been staring at that formula trying to find something like that. However, now I get an incorrect argument error.

=SUMIFS({CRA MV Report Metrics Range 5}, [CRA Name]@row, {CRA MV Report Metrics Range 2}, [Visit Type]@row, {CRA MV Report Metrics Range 4}, [Visit Type Description]@row, {CRA MV Report Metrics Range 3})

Paul Newcome

SUMIFS does not have the same syntax as SUMIF. In SUMIFS, the range to sum comes first, then you start your range/criteria sets. It looks like maybe you just need to move range 3 to the beginning and shift everything else on over.

Michelle B

@Paul Newcome

Range 5 is what I am summing. However, I do have the criteria and criteria range backwards. I have fixed the formula and it looks to be working.

Thank you @Paul Newcome and @ker9 for the fast responses!!

Paul Newcome

That too. Hahaha

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