Need Help on Excel Formulas

[abhisjekmissile]

Size Small Medium Large
Flavour Original Coconut Smoothie Parfait
Topping 1
Topping 2
Topping 3
Topping 4
Topping 5
Topping 6
Extra Toppings
Total = ?????

W/out with toppings
Small Original 12 22
Medium Original 18 31
Large Original 24 36

Small Flavour 14 23
Medium Flavor 22 33
Large Flavour 28 38
Smoothies 22
Large Smoothie 29
Parfait 28


I want to make sheet in Excel where if u add small or medium or large original with topping or without topping or any other flavor the prize should cm on Total. Please let me know if this is exp.

Please advice.. if this works.. Life will be at ease

 

[texasalynn]

Welcome to MrExcel Board....

not sure if the typos have this as unclear? But I'm not understanding