+ Reply to Thread
Results 1 to 6 of 6

Adding multiple cells based on the result of a data validation cell

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Adding multiple cells based on the result of a data validation cell

    Good Evening - I really need your expert help. I have an excel spreadsheet that displays the dollar amounts in columns B11 to B103 and also in column G11 to G103. I created a drop down list in columns E and J that have the following list "Tithes", "Building Funds", "offerings" and other. What SUMIF formula do I use to add up all the tithes amounts, building fund amounts, etc.? I tried to understand the following created for a previous post, but couldn't get it to match my needs. Thank you!

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Adding multiple cells based on the result of a data validation cell

    could you please attach a workbook? without knowing the layout of your sheet i cannot provide you a solution.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Adding multiple cells based on the result of a data validation cell

    Tried to work out what you required, hope the attached sheet helps.
    Attached Files Attached Files

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Adding multiple cells based on the result of a data validation cell

    Sorry i missed your responce, is this issue still outstanding?

  5. #5
    Registered User
    Join Date
    03-19-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding multiple cells based on the result of a data validation cell

    I know my reply is months later, but I wanted to sincerely say THANK YOU for this "right on target" response. It has helped me out tremendously and I am all set. Thank you for offering your expertise to novices like me. All the best in 2013!

  6. #6
    Registered User
    Join Date
    03-19-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding multiple cells based on the result of a data validation cell

    BarryTSL - I used your formula! Woohoo! Thank you!

+ 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