+ Reply to Thread
Results 1 to 5 of 5

Calculation Based On Dropdown list Selection Excel

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post Calculation Based On Dropdown list Selection Excel

    I need your help!

    I've been visualizing this but I don't know what to do.

    I have a Sales Monitoring excel sheet for manual inputs. I have also a Summary sheet to show the total Revenue and Cost based on the dropdown selection.

    The Sales Monitoring Sheet has four categories namely facebook likes, twitter followers, youtube views, website traffic. Each has specific amount in of Revenue, cost and profit to be entered manually in Sales monitoring sheet.

    Now, what I want to do is the Sales Summary sheet - should calculate the total Revenue, Paypal fee, cost and profit for each category. There should be a dropdown list of the category (facebook likes, twitter followers, youtube views, website traffic) and in the other columns should have the total cost/profit for all of the sales in that category.

    So, when I select "Facebook likes" category (dropdown lists) in the Sales Summary, it will classify all the entries from the Sales Monitoring sheets, sum it up and display automatically to the total Revenue, Paypal fee, cost and profit columns of the Sales Summary sheet.

    I have attached the sample worksheet.

    Thank you so much for your help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Calculation Based On Dropdown list Selection Excel

    Hello,

    Please check if the attached file is what you are looking for.
    Attached Files Attached Files
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Calculation Based On Dropdown list Selection Excel

    Hello Lem,

    Very excellent! How did you do that? . Impressive!

    Thank you so much!

  4. #4
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Calculation Based On Dropdown list Selection Excel

    I used the following formula on Cell C3
    Please Login or Register  to view this content.
    Basically the first part is the "Look for" - if the Cell on the left of the formula ("Facebook Likes" on this example) is found on the Services Category column on Table1 worksheet, then take the value on worksheet Table1 column Revenue on the same row in which it's found, then add them together.

    Anyway, glad that I could help. If this is the solution you are looking for, please mark the thread as [SOLVE] using the Thread tools right above the #1 post.

    Have a great day.

  5. #5
    Registered User
    Join Date
    04-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Calculation Based On Dropdown list Selection Excel

    Wow! thank you so much once again...Have a great day too!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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