+ Reply to Thread
Results 1 to 3 of 3

Sumif & Sumproduct combination

  1. 10-09-2009, 06:02 AM #1
    rickyilas
    rickyilas is offline
    Forum Contributor
    Join Date
    08-24-2009
    Location
    Manila, Philippines
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    120

    Sumif & Sumproduct combination

    Hello guys,

    I need help in combining sumif & sumproduct. I have attached a file which explains what I need.

    Hope somebody could help. Thanks
    Attached Files Attached Files
    Last edited by rickyilas; 10-09-2009 at 09:35 AM.
    Reply With QuoteRegister To Reply
  2. 10-09-2009, 07:01 AM #2
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Sumif & Sumproduct combination

    In B20:

    =SUMPRODUCT(($A$7:$A$13=$A20)*($D$5:$O$5=1)*($D$7:$O$13))

    In C20:

    =SUMPRODUCT(($A$7:$A$13=$A20)*($D$4:$O$4=1)*($D$7:$O$13))
    Reply With QuoteRegister To Reply
  3. 10-09-2009, 09:30 AM #3
    rickyilas
    rickyilas is offline
    Forum Contributor
    Join Date
    08-24-2009
    Location
    Manila, Philippines
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    120

    Re: Sumif & Sumproduct combination

    Thanks Stephen! It worked exactly what I needed.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1