Index / Match with multi select criteria

Jörg Schmidt1

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

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))