Index / Match with multi select criteria

I use a price calculating sheet for various criteria f.e. client or not, booking on short or long term and so on. A possible client uses a form to answer the questions and the price will be shown in another sheet "lead management" and the price will be offered to the interested people by an automation process.

Is it possible to change the formula using multi select criteria - in the example sheet

column "Extras" a client would choose f.e. if he/she wants

accomodation (Unterkunft) = 1.449,42 € and also
food
beverages

Find more posts tagged with

Accepted answers

All comments

Darren Mullen

@Jörg Schmidt1 I think I know what you are asking. If what you are looking to match will only result in one unique match, does this help?

https://youtu.be/a0BnrRwm_Bg

Paul Newcome

You are going to need a SUMIFS along the lines of...

SUMIFS({Range To SUM}, {Range To Match On}, HAS([Multi-Select Column Name]@row, @cell))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.