# Excel Problem, using sum function when value changes. HELP!!!! URGENT!!

1. ## Excel Problem, using sum function when value changes. HELP!!!! URGENT!!

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

2. ## Re: Excel Problem, using sum function when value changes. HELP!!!! URGENT!!

You're better off uploading a spreadsheet here.

Attach a sample workbook or put a link to it here
Make sure there is enough data to demonstrate your needs
Include a BEFORE and AFTER sheet in the workbook to show what you're trying to achieve
Make sure your desired results are shown, mock them up manually if necessary
Remove any sensitive data

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1