+ 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
    196

    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,833

    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
    196

    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,833

    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)

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