Hi all.
Supposing you are selling Greek Yogurt and the customer asks you for different toppings.
I want o have an Excel spreadsheet where you scrolling down you can choose one of each element (Fruits, Toppings, Nuts) and at the end you have the total price.
Honesty no idea how to do it.


Cheers, Adrian

Attached Files

Yogurth.xlsx (8.5 KB, 8 views)

Here are a couple of different approaches to your question. (see attached sample file)

FILTER TAB: uses filters in column A and subtotals for TOTAL formula

SUMIF TAB: uses X in column C and sumif for TOTAL formula

Attached Images

Yogurt Options.jpg (51.8 KB, 19 views)

Attached Files

Yogurth Options.xlsx (13.1 KB, 10 views)

Thanks ProdudLiberal.
The first option looks more elegant