+ Reply to Thread
Results 1 to 3 of 3

Sum multiple entire rows based on criteria, array formula challenge!

  1. #1
    Registered User
    Join Date
    09-12-2011
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Sum multiple entire rows based on criteria, array formula challenge!

    I have made an attachment with information.

    I want to be able to sum an entire row up to a certain column based on criteria. I have tried multiple methods and have failed. I am fairly proficient with array formulas and I am pretty sure it is possible. Hopefully one of you true experts can help.

    Thanks
    Peter
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Sum multiple entire rows based on criteria, array formula challenge!

    Hello Peter,

    Try..

    =SUMPRODUCT(($B2:$B7=1)*($C2:C7))

    Copy across.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    09-12-2011
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Sum multiple entire rows based on criteria, array formula challenge! [Solved]

    Thank you Haseeb. That was so simple I'm slightly embarrassed I said I knew a reasonable amount of array formulas.

    I thought I had tried that but apparently I did not.

    Thanks again!

+ 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