SUMIFS formula with multiple criteria help

AlexisJ

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

=SUMIFS({Registration Cost}, {Requestor Email}, "jdoe@company.gov") - 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}, "jdoe@company.gov", AND(OR({Wish List}, 1))))

It is coming back as #unparseable

JamesB

@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], "jdoe@company.gov", [Wish List]:[Wish List], 1)

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

JamesB

@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], "jdoe@company.gov", [Wish List]:[Wish List], 1)

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

AlexisJ

@JamesB It worked! Thank you.

JamesB

Your Welcome