+ Reply to Thread
Results 1 to 3 of 3

Can I use sumifs on a range with multiple columns?

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Can I use sumifs on a range with multiple columns?

    Hi guys and girls,

    I set my range as follows :

    Please Login or Register  to view this content.
    This gives me two ranges with multiple columns of data, which should work fine.

    then try to gather my data as follows :
    Please Login or Register  to view this content.
    But this DOESN'T work - it seems like SumIfs doesn't work with a range with multiple columns... ? Anyone know a workaround for this problem? Thanks in advance!
    The code DOES work if the rng2013/rng2014 ranges have only one column of data instead of more...
    I really need this to work, please help!
    Last edited by JasperD; 08-13-2014 at 02:51 AM. Reason: (and girls! - and state that it DOES work when the ranges just contain one column!)

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Can I use sumifs on a range with multiple columns?

    Remarks from Excel Help regarding SUMIFS:
    Unlike the range and criteria arguments in the SUMIF function, in SUMIFS each criteria_range must be the same size and shape as sum_range.
    That probably explains why it didn't work for you. You probably need a loop to do the sum row by row/column by column.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Can I use sumifs on a range with multiple columns?

    Your rng2013 possess two column range which passed in SumRange of SumIfs() function which causing the trouble.

    Because SumIf(s) will accept single column range only.

    Please confirm what you are trying to do with this offset()?

    rng2013.Offset(0, 1)

    Because that will also result the Two Column range only


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Multiple Criteria Sumifs in Multiple Columns
    By arowberry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2014, 06:06 PM
  2. Need help understanding sumifs columns with multiple criteria
    By igoodable in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2014, 02:27 PM
  3. Sumifs with multiple criteria in multiple columns
    By Ganesh7299 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2013, 01:30 AM
  4. SUMIFS with multiple sum range columns
    By bvmk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 03:39 PM
  5. [SOLVED] SUMIFS and multiple parameters across rows and columns
    By george_k in forum Excel General
    Replies: 4
    Last Post: 11-02-2012, 02:56 PM

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