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
-
Apologies. You also need quotes around "FY 20". I noticed it but forgot to add them when I redid the formula.
=SUMIFS({FY Amount}, {FY}, "FY 20" , {FY Contracts, CEAs, & Sponsorships Range 4}, "Sponsorship", {Approved}, OR(CONTAINS("Approved", @cell), CONTAINS("CXL - COVID19", @cell)))
Answers
-
Try something like this...
=SUMIFS({FY Amount}, {FY}, FY 20 , {FY Contracts, CEAs, & Sponsorships Range 4}, "Sponsorship", {Approved}, OR(CONTAINS("Approved", @cell), CONTAINS("CXL - COVID19", @cell)))
-
Hey, thanks for quick reply!
It's still coming up as unparseable though
-
Apologies. You also need quotes around "FY 20". I noticed it but forgot to add them when I redid the formula.
=SUMIFS({FY Amount}, {FY}, "FY 20" , {FY Contracts, CEAs, & Sponsorships Range 4}, "Sponsorship", {Approved}, OR(CONTAINS("Approved", @cell), CONTAINS("CXL - COVID19", @cell)))
-
That worked! Thanks so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!