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.

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

Was the first formula copied correctly? There is a mismatch in the number of opening/closing parentheses in both formulas.

Todd Smelser

I think so. First formula works great, and has been for over a year

Carson Penticuff

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

Todd Smelser

I get "#INCORRECT ARGUMENT SET". When I try that.

Todd Smelser

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.