Using the CONTAINS function

I am attempting to add a search criteria to an existing function. The current, working function is
=SUMIFS({Total Seat Count}, {Region}, ="US East") + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East")
I would like to create a new function that will specify a count with a specific unit name "VFX" found in the column "VM Name".
=SUMIFS({Total Seat Count}, {Region}, ="US East", ({VM Name}, CONTAINS("VFX", @cell)) + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East") + 43)
I believe I am formatting this as given in this example on SS:
([Sold Date], CONTAINS("1:55 AM", @cell))
However, I get unparseable so can't figure out where I am going wrong.
Answers
-
Was the first formula copied correctly? There is a mismatch in the number of opening/closing parentheses in both formulas.
-
I think so. First formula works great, and has been for over a year
-
I'm not sure if this is what you are looking for. I removed a couple of parentheses that I'm not sure should have been there.
=SUMIFS({Total Seat Count}, {Region}, ="US East", {VM Name}, CONTAINS("VFX", @cell)) + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East") + 43
-
I get "#INCORRECT ARGUMENT SET". When I try that.
-
Well, I think I have it.
=SUMIFS({Total Seat Count}, {VM Name}, CONTAINS("us-e-vfx", @cell), {Region}, "US East")
Seems to work but the SUM is off...I'll work that out
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!