Results 1 to 9 of 9

Thread: Sum values based on multiple criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    19
    Rep Power
    0

    Sum values based on multiple criteria

    Hi

    I would really appriciate if I could get some help with this dilemma.

    In the yellow cell I want a formula that can sum up all the numbers in row D, based on which account numbers I choose in the box in row J. They have to be linked to the account number in row C.
    So since I already have choosen the numbers 4000 and 4050, the amount in the yellow cell should be 47275.

    I also have to be able to change the numbers in the box to get new results as I please. I need to be able to choose account numbers and automatically get new answers in the yellow cell.

    Thank you!

    Dilemma.xlsx
    Last edited by Jorrg1; 01-04-2013 at 02:40 PM.

Similar Threads

  1. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. SUM Value With Multiple Criteria In Same Column
    By MarkJohn in forum Excel Help
    Replies: 2
    Last Post: 05-18-2012, 07:52 AM
  3. Sum values based on multiple criteria
    By vmath in forum Excel Help
    Replies: 1
    Last Post: 05-07-2012, 08:53 AM
  4. Fetch multiple values based on criteria
    By Lucero in forum Excel Help
    Replies: 8
    Last Post: 04-07-2012, 12:35 PM
  5. SUM with Multiple Criteria
    By candygirl in forum Excel Help
    Replies: 5
    Last Post: 12-11-2011, 03:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •