Results 1 to 2 of 2

SUMIFS with Date Referenced in Cell

Threaded View

  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

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