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?
Best Answer
-
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!!
Answers
-
Hi @Michelle B
It may be due to a double }} before the first comma:
=SUMIFS({CRA MV Report Metrics Range 5}},
Hope that helps!
-
@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})
-
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.
-
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!!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
