+ Reply to Thread
Results 1 to 4 of 4

Drawing a serious blank - criteria in SUMIF formula to be < a cell value

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    California - US
    MS-Off Ver
    MS 2010
    Posts
    27

    Drawing a serious blank - criteria in SUMIF formula to be < a cell value

    Hello all,

    I'm getting some issues when I'm trying to add a SUMIF formula to reference a cell value for the criteria. For example, if cell A1 is 15, this is where I'm at but it's showing no values:

    =SUMIF(CRITERIA RANGE,"<=A1",SUM RANGE)

    Any ideas? Thanks!!
    Scott

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,664

    Re: Drawing a serious blank - criteria in SUMIF formula to be < a cell value

    Try:

    =SUMIF(CRITERIA RANGE,"<="&A1,SUM RANGE)
    Glenn



  3. #3
    Registered User
    Join Date
    03-17-2017
    Location
    California - US
    MS-Off Ver
    MS 2010
    Posts
    27

    Re: Drawing a serious blank - criteria in SUMIF formula to be < a cell value

    Yep that's perfect - thanks!! Marked as solved

    Scott

  4. #4
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,664

    Re: Drawing a serious blank - criteria in SUMIF formula to be < a cell value

    You're welcome.



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

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. 'Sumif' Formula with multiple criteria in one cell
    By stuart010 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-04-2016, 09:36 AM
  2. Replies: 9
    Last Post: 07-21-2016, 07:03 AM
  3. Help with sumif formula using a cell for criteria
    By ExcelFailure in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2015, 03:36 AM
  4. [SOLVED] Simple Column formula.. should be anyway.. but drawing a blank!
    By sammymalta in forum Excel General
    Replies: 4
    Last Post: 09-05-2013, 09:21 AM
  5. sumif for non-blank criteria
    By dellphinus in forum Excel General
    Replies: 10
    Last Post: 11-03-2008, 08:03 AM
  6. How do I use the criteria "is not blank" in a SUMIF formula?
    By Pretender in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2006, 02:55 PM
  7. how to write 'not equals blank' criteria in SUMIF
    By David in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2005, 01:06 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