+ Reply to Thread
Results 1 to 5 of 5

Sumproduct with multiple Conditions

  1. #1
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Sumproduct with multiple Conditions

    Hi,

    Please help, I wants to use Sumproduct with two conditions to get data on Sheet 1 from Sheet 2.

    Please see the attachment.

    Thanks in Advance.Dealer Offtake.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,528

    Re: Sumproduct with multiple Conditions

    Try this......

    Please Login or Register  to view this content.
    Then copy across and down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Sumproduct with multiple Conditions

    or
    =SUMPRODUCT((Sheet2!$A$2:$A$140=$A3)*(Sheet2!$B$2:$B$140=B$2),Sheet2!$C$2:$C$140)
    but as you in Excel 07
    =SUMIFS(Sheet2!$C$2:$C$140,Sheet2!$A$2:$A$140,$A3,Sheet2!$B$2:$B$140,B$2)
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  4. #4
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Re: Sumproduct with multiple Conditions

    Wow, That's worked like a charm..

    Thanks both SKTNEER and Robert Mika for a very quick reply's...THANKS!!!

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,528

    Re: Sumproduct with multiple Conditions

    Glad to help you. Thanks for the feedback.
    Please mark your thread as solved if you are satisfied with the answer provided and you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum.

+ 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] Sumproduct with multiple conditions help
    By Murphy15 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2013, 03:28 PM
  2. Multiple (3) SUMPRODUCT conditions
    By timjames in forum Excel General
    Replies: 2
    Last Post: 11-03-2011, 03:17 PM
  3. Sumproduct - Using multiple conditions
    By EXCELNEWCOMER in forum Excel General
    Replies: 5
    Last Post: 02-11-2010, 04:43 PM
  4. Sumproduct - multiple conditions
    By rasonline in forum Excel General
    Replies: 10
    Last Post: 06-04-2009, 05:10 PM
  5. Sum with multiple conditions:SUMPRODUCT
    By will.00 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2007, 03:51 AM

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