Screen Shot 2015-03-24 at 12.21.06.pngI have a drop down list with options of 5 fruits.
If you choose one of the fruits, there are cells below that automatically change there text to the appropriate value, e.g weight, selling price.. So when you choose a different fruit it calculates the value for selling price for example . This was done using if statements.
Is there a way to calculate a total for all the selling prices.
e.g when fruit 1 is selected add price when fruit 2 is selected add price when fruit 3 is selected.
So it would give a total selling price for all fruits.
I am using 2011 excel for mac
Any help would be greatly appreciated
PLEASE SEE IMAGE,
AS YOU CAN SEE IF YOU CHOOSE ONE OF THE FRUITS IT CHANGES THE DATA IN THE FIELDS BELOW
HOW CAN I CALCULATE A SUM FOR ALL THE BUYING COSTS FROM ALL OPTIONS
Bookmarks