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

Options
Michelle B
Michelle B ✭✭
edited 06/02/23 in Formulas and Functions

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

  • Michelle B
    Michelle B ✭✭
    edited 06/02/23 Answer ✓
    Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!