+ Reply to Thread
Results 1 to 2 of 2

SUMIFS with Date Referenced in Cell

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Somewhere Out There
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    11

    Question SUMIFS with Date Referenced in Cell

    I am trying to only SUM Certain Cells if it's the right BIN Number and the Transaction Date is after the Inventoried Date.

    If I format the formula with the date function like this =SUMIFS(Transaction_QTY,Transaction_BIN,[@BIN],Transaction_Date,">="&DATE(2016,6,1)) It works fine.

    However, If I try and replace that ">="&DATE() with a cell reference it gives me 0.
    Both columns are set to the date type.

    I've added an attachment of what I'm working with.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-23-2012
    Location
    Somewhere Out There
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    11

    Re: SUMIFS with Date Referenced in Cell

    Figured it out. When referencing the Cell I needed to place a "&" in front of the Cell reference.

    ...,">="&E2 worked.

+ 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. SUMIFS with date range as a cell reference
    By malagajm in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-05-2016, 07:52 AM
  2. [SOLVED] Autofilling cell with todays date, and some SUMIFS configuration
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2015, 08:47 PM
  3. Value in one cell based on day of week referenced by a date in another cell
    By gibson2503 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2013, 12:05 PM
  4. Replies: 6
    Last Post: 10-30-2011, 04:14 AM
  5. SumIFS() filtered by the month of a date cell
    By truecrisis in forum Excel General
    Replies: 2
    Last Post: 07-06-2010, 07:57 AM
  6. Replies: 1
    Last Post: 05-29-2005, 07:05 PM
  7. Cell referenced to current date
    By stryker in forum Excel General
    Replies: 5
    Last Post: 02-03-2005, 09:31 AM

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