+ Reply to Thread
Results 1 to 12 of 12

Make an addition formula that adds up totals separately for each option in a drop down?

  1. #1
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Make an addition formula that adds up totals separately for each option in a drop down?

    Hi guys,

    Capture.JPG


    basically I was wondering if there was a way that I could make the formula (which is just sum) add, but add separately for each option in a drop down?

    for example, if i select "a" in the drop down, i can input everything I need and the total will be calculated.
    then, I can select "b" from the drop down, and all the cells revert back to zero, and only the total of what i input in b will be calculated.

    so when I go back to "a" only a's input and total are there, and when i go to "b", only b's input and total are there?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Hi saudxkhan,

    From where the data will arrive ?
    Or you want to input the data manually ?

    if possible, please upload a sample workbook. Thanks.

    Regards,
    DILIPandey


    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Quote Originally Posted by dilipandey View Post
    Hi saudxkhan,

    From where the data will arrive ?
    Or you want to input the data manually ?

    if possible, please upload a sample workbook. Thanks.

    Regards,
    DILIPandey


    <click on below 'star' if this helps>
    Hi dilip, how do i upload the workbook here?

    ---------- Post added at 12:31 PM ---------- Previous post was at 12:29 PM ----------

    I would like to input the data manually. basically I will be carrying this around on a tablet and adding as i go along my day
    Last edited by saudxkhan; 08-12-2012 at 12:36 PM.

  4. #4
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Okay, so basically in each place that it says "module" there is a dropdown with a, b, c, d, and e.

    Is there a way that the totals at bottom work separately for each a, b, c, d, and e?
    Attached Files Attached Files

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Yes..that is achievable.. and I guess you can use SUMIF/ SUMIFs function here after little modification in data arrangement... but why are you summing up NAME, DOB etc.. these are supposed to be text values ?

    If you have some other point, choose B2 and B7 as a and then B12 and B17 as b, enter some data for NAME, DBOB etc..and show me which sum you want and where it should appear .. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  6. #6
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Thanks again, I have to add up how many times name, dob or both are used depending on the worker in the hospital. I will be adding up that manually as I see it during the day. Could you walk me through the steps, sir? I'm very very new at excel.

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Okay.. so you need to count the occurrence of the names.. look into CountIF and CountIFs function and let me know if that works in your case.

    Also, as I asked earlier please share some scenario and upload a sample excel workbook.. thanks.
    choose B2 and B7 as a and then B12 and B17 as b, enter some data for NAME, DBOB etc..and show me which sum you want and where it should appear .. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  8. #8
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    yes! the occurences. here is a copy of it. basically, each place that says, "module" there is a dropdown for a through e. If it is possible to make the totals at the bottom work specifically for each a, b, c, d, and e.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    I am not sure what countIF is. I'm googling it (this is honestly my first time using excel!) I've attached the workbook, could you maybe take a look at it?
    Attached Files Attached Files

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Hi Saudxkhan,

    See the attached workbook.. change the drop down values in yellow cell, you'll see the change in green cell..let me know if this helps. thanks.
    AmbcarePtID(1).xls

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  11. #11
    Registered User
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Hi sir, no, that is not what i meant.

    each place next to the number named module has a-e. next to each name and dob will be numbers I will be adding manually. Is it possible for when I change the dropdown for A the numbers i entered and the totals only be for that A? and the b only be for that b?

    I'm sorry I dont know many of the terms and everyhing!

  12. #12
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make an addition formula that adds up totals separately for each option in a drop down

    Hi saudxkhan,

    You can change the yellow reference to above cells containing data validation.
    If would still suggest you to put some number manually and share the sample workbook...Please upload. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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