Formula to Evaluate Multi-Selection and Sum Individual Associated Values

Brian McElligott · 01/16/25

I may be asking too much in terms of formula functionality, but here is my goal / question:

I have the following columns:

Item - These are items that can be selected by the user, multiple items are allowed

Price - Price per item

User Selection - Received from a form

Total Cost - The cost of the selection(s)

I am using an Index / Match function to pull data into Total Cost:

=INDEX(Price1:Price3, MATCH([User Selection (Multi-Select Drop Down)]@row, Item1:Item3, 1))

Can I / How Can I get a total Cost for the situation where multiple selections are made (Option A and Option B)?

Thoughts?

Leibel S · 01/16/25

See below how you would do that:

=SUMIFS(Price1:Price3, Item1:Item3, HAS([User Selection (Multi-Select Drop Down)]@row, @cell))

Leibel S · 01/16/25

See below how you would do that:

=SUMIFS(Price1:Price3, Item1:Item3, HAS([User Selection (Multi-Select Drop Down)]@row, @cell))

Brian McElligott · 01/16/25

Thank you!!! I am trying to understand your formula, but it totally works.

Formulas and Functions