+ Reply to Thread
Results 1 to 4 of 4

How to do Sumif with multiple columns

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    How to do Sumif with multiple columns

    Dear Friends,

    PFA

    Is there any formula which can produce the output mentioned in col J, K, L?

    There are approx. 35 columns and 100 rows. The issue is sequence of columns keep changing. But output will remain the same.

    Please assist.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: How to do Sumif with multiple columns

    J3 =IFERROR(INDEX($B$3:$F$3,MATCH(0,COUNTIF($I3:I3,$B$3:$F$3),0)),"") Ctrl Shift Enter
    Drag to the right

    J4=SUMPRODUCT(($B$4:$F$7)*($A$4:$A$7=$I4)*($B$3:$F$3=J$3))
    Drag to the right and down

    See attachment.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    205

    Re: How to do Sumif with multiple columns

    Wow.... thanks a lot.
    You made my day.
    God bless you.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: How to do Sumif with multiple columns

    You're welcome. Happy to help.

    Thanks for the rep!

+ 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] Conditional SUMIF based on multiple columns and multiple row variables
    By jaymaan74 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-15-2016, 11:05 AM
  2. Using SUMIF across multiple columns
    By BobTheRocker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2011, 01:03 PM
  3. SUMIF over multiple columns
    By SueJ in forum Excel General
    Replies: 2
    Last Post: 05-25-2010, 09:56 AM
  4. SUMIF multiple columns
    By mperemsky in forum Excel General
    Replies: 5
    Last Post: 06-15-2009, 02:41 PM
  5. SUMIF for multiple columns
    By makku in forum Excel General
    Replies: 5
    Last Post: 11-18-2008, 11:37 AM
  6. Sumif for multiple columns
    By bigbill3599 in forum Excel General
    Replies: 4
    Last Post: 06-06-2008, 02:10 AM
  7. [SOLVED] SUMIF with multiple criteria for multiple columns to sum a single
    By SavageMind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 11:05 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