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

Michelle B

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?

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!!

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.

=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!!

Paul Newcome

That too. Hahaha

Happy to help. 👍️