Results 1 to 2 of 2

Thread: SUMIF with dates

  1. #1
    Junior Member
    Join Date
    Jun 2012
    Posts
    3
    Rep Power
    0

    SUMIF with dates

    Hi all
    I'm doing a formula using SUMIF
    When the criteria in the formula is a date, it returns 0 Why ? I don't know
    My formula is
    Code:
    =SUMIF(DEBTS!$A$5:$C$150;D2;DEBTS!$C$5:$C$150)

    D2 is a cell that have a date
    this formula results 0 value
    even though it returns correct values if D2 is not a date
    Hope I'm clear enough
    using office Excel 2003
    waiting

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Either your dates in date range or the criteria range is not a proper date value.

    what the following gives ?

    =isnumber(d2)

    and

    =isnumber(DEBTS!$A$5)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Sumproduct and Sumif in vba in large datasheet
    By Jean72 in forum Excel Help
    Replies: 1
    Last Post: 02-08-2016, 07:41 PM
  2. Insert Missing Dates By Comparing Two Lists Of Dates
    By mahmoud-lee in forum Excel Help
    Replies: 24
    Last Post: 10-16-2013, 04:48 PM
  3. SUMIF COUNTIF To Look For More Than One Keyword
    By william516 in forum Excel Help
    Replies: 1
    Last Post: 08-06-2013, 12:03 AM
  4. How to Extracting dates and days between 2 dates.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 9
    Last Post: 08-11-2012, 09:11 PM
  5. Help with a Vlookup and SUMIF
    By Lucero in forum Excel Help
    Replies: 4
    Last Post: 07-24-2012, 05:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •