+ Reply to Thread
Results 1 to 4 of 4

Conditional sums based on conditional drop down selections

  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    london england
    MS-Off Ver
    2013
    Posts
    2

    Conditional sums based on conditional drop down selections

    My excel sheet looks something like this:

    Animal | Weight | Date
    ______________________
    Dog 5 Jan/1/2015
    Cat 2 Feb/19/2015
    Cow 9 Jan/2/2015
    Cow 6 Jan/1/2015
    Dog 1 Jan/1/2015
    Dog 4 March/1/2015


    I then would like a to have out like this where the first column is a drop down, the second is a dropdown as well and the third is a total:


    Choose Animal | Choose Month | Sum of all the weight
    _______________________________________________
    [Dog,Cow,Cat] | [Jan - Dec] | [Sum of the animal chosen for that month]


    So I would like to choose an animal, then choose a month and it should sum the weight. For example if I chose Dog and Jan the total weight should equal 6 (5+1). I am unsure how to accomplish this as it needs to take the sum from the first section, but the criteria for that section is based on the dropdown values of the the second section (unsure if I can even create dropdowns such as this?)

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Conditional sums based on conditional drop down selections

    Here is a solution
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    3-10-2016 2-32-40 AM.jpg

    Here is your example in action
    https://youtu.be/pRA-zkAzPVs
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Conditional sums based on conditional drop down selections

    Upload a sample file.

  4. #4
    Registered User
    Join Date
    03-10-2016
    Location
    london england
    MS-Off Ver
    2013
    Posts
    2

    Thumbs up Re: Conditional sums based on conditional drop down selections

    PERFECT! Thanks so much EXACTLY what I needed! Your are Batman!

+ 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. [SOLVED] Conditional value based on drop down list
    By confusedconfucious in forum Excel General
    Replies: 5
    Last Post: 03-05-2014, 12:18 PM
  2. [SOLVED] Conditional Formatting of List based on selections from Dropdown list
    By FoxyPinkChick in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 03:32 AM
  3. Replies: 1
    Last Post: 07-27-2012, 01:04 AM
  4. [SOLVED] Conditional Sums based on data entry
    By WRL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2012, 07:00 AM
  5. Replies: 0
    Last Post: 08-04-2010, 05:20 PM
  6. Replies: 10
    Last Post: 11-19-2009, 04:51 PM
  7. Conditional Formatting based on a drop down list
    By erica6670 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2008, 12:35 PM
  8. Two sums of column based on conditional split
    By Lope in forum Excel General
    Replies: 3
    Last Post: 04-08-2008, 09:41 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