+ Reply to Thread
Results 1 to 4 of 4

SUMIFS with two columns in range

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    2

    Question SUMIFS with two columns in range

    Hello everyone,

    How can I use the SUMIFS function to sum all the values in a range using a criteria? Here's an example:

    duda excel.JPG

    I want to sum all the values in B2:C6 which are between and including G2 and G3.

    Here's my formula: =SUMIFS(B2:C6,A2:A6,">="&G2,A2:A6,"<="&G3) but it returns a #Value! error

    Any suggestions? Thank you very much!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIFS with two columns in range

    SUMIFS will not work in that way.

    Try this...

    =SUMPRODUCT((A2:A6>=G2)*(A2:A6<=G3)*B2:C6)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    04-04-2016
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    2

    Re: SUMIFS with two columns in range

    It worked like a charm. Thank you so very much!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIFS with two columns in range

    You're welcome. Thanks for the feedback!

+ 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. Replies: 3
    Last Post: 12-09-2015, 03:10 AM
  2. Sumifs to extend across columns
    By sarinky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2015, 08:40 AM
  3. Can I use sumifs on a range with multiple columns?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 03:11 AM
  4. [SOLVED] Trying to sumifs with 3 columns
    By avendi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2014, 08:57 PM
  5. sumifs on a pivot table - compare range with range
    By pavlos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 02:26 AM
  6. SUMIFS with multiple sum range columns
    By bvmk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 03:39 PM
  7. [SOLVED] IF AND or SUMIFS comparing Months from 2 date columns and text from 2 other columns
    By jrochet in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-22-2012, 11:06 AM

Tags for this Thread

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