SUMIFS with Multi-Select Criteria

Trying to correct my SUMIFS formula include two criteria from a multi-select column. I'm currently getting UNPARSABLE every time try OR, AND, or HAS.

Here's what I have so far with my current criteria, I just need to add an additional option for "CXL - COVID19" in addition to "Approved":

=SUMIFS({FY Amount}, {FY}, FY 20 , {FY Contracts, CEAs, & Sponsorships Range 4}, "Sponsorship", {Approved}, "Approved")

Any help is greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!