+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    03-24-2015
    Location
    London
    MS-Off Ver
    office 2011 mac
    Posts
    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
    Last edited by paphitis; 03-24-2015 at 08:23 AM. Reason: IMAGE

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    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
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Urgent VBA excel Problem
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2010, 11:34 AM
  2. Urgent HELP for Formula for a date problem on Excel!
    By flip_360_2002 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2006, 12:14 PM
  3. Excel problem - urgent
    By infodata in forum Excel General
    Replies: 1
    Last Post: 05-12-2006, 11:50 AM
  4. Urgent Help Required on Excel Macro Problem
    By Sachin Shah in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 01:26 AM
  5. Excel Macro Count Problem ---- Urgent
    By nithinramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2005, 01:16 AM

Tags for this Thread

Bookmarks

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