+ Reply to Thread
Results 1 to 4 of 4

SUMIF formula for count of other column between 2 numbers?

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    SUMIF formula for count of other column between 2 numbers?

    Hi there,

    Please see below for a formula that is returning - when a value should appear:

    =SUMIF(D11:D273,">=1""<=30",C11:C188)

    Basically, column D is a column with aging days.
    column C is a column with amounts due for the aging days.

    What I want the formula above is to come up with is to sum up all amounts (from column C) where the aging days from column D is between 1 and 30.

    Any advice where I am going wrong?

    Regards

    Nim

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,507

    Re: SUMIF formula for count of other column between 2 numbers?

    You have two conditions, so you will need to use SUMIFS, like this:

    =SUMIFS(C11:C273,D11:D273,">=1",D11:D273,"<=30")

    Note that the ranges need to be the same size.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: SUMIF formula for count of other column between 2 numbers?

    Thanks for the quick reply Pete, it has worked

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,507

    Re: SUMIF formula for count of other column between 2 numbers?

    Glad to hear it - thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Pete

+ 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. Combining SUMIF and Subtotal for a single column of numbers
    By mosesthetank in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2014, 04:15 PM
  2. Replies: 8
    Last Post: 03-03-2014, 06:53 AM
  3. [SOLVED] Count repeat numbers in column B based on a condition from Column Al
    By helpbitte in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2012, 10:11 AM
  4. Formula to count how many numbers repeat in a column.
    By simonheller in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2010, 06:43 PM
  5. Count if formula that works like sumif
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-29-2010, 05:01 PM
  6. Sumif where a column has segmented numbers
    By dond in forum Excel General
    Replies: 1
    Last Post: 07-06-2009, 01:11 AM
  7. Count formula, lookup or may sumif?
    By JapanDave in forum Excel General
    Replies: 2
    Last Post: 06-22-2009, 05:38 AM
  8. Column Has Text and Numbers, Need To SUMIF Only Numbers
    By Karleajensar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2008, 01:27 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