SUMIFS formula with multiple criteria help

I have a formula that works but once I add additional criteria it breaks.

=SUMIFS({Registration Cost}, {Requestor Email}, "") - This formula works.

Now I need to sum the cost if it is assigned to a specific person AND the Wish List box is checked.

=SUM({Cost}, {Requestor Email}, "", AND(OR({Wish List}, 1))))

It is coming back as #unparseable

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    edited 09/06/23 Answer ✓

    @AlexisJ This is still a SUMIFS. The formula written below is if the reference information is in the same sheet.

    =SUMIFS(Cost:Cost, [Requestor Email]:[Requestor Email], "", [Wish List]:[Wish List], 1)

    IF The Requestor Email is not or Wish List is not Checked, then the SUMIFS formula is false and will not perform the calculation.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!