+ Reply to Thread
Results 1 to 8 of 8

Return next date and sumif error.

  1. 11-28-2014, 11:15 AM #1
    kborgers
    kborgers is offline
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Question Return next date and sumif error.

    Thanks all for your prompt assistance!
    Attached Files Attached Files
    Last edited by kborgers; 11-28-2014 at 11:36 AM.
    Reply With QuoteRegister To Reply
  2. 11-28-2014, 11:24 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Return next date and sumif error.

    It looks like you have the wrong quotation marks

    ”Yes” and it should be "Yes"
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 11-28-2014, 11:28 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Return next date and sumif error.

    In your SUMIF formula, the double quotes around the text Yes are not correct double quotes (no idea what they are). Try retyping them ( I don't get the same cocde for your quotes (138) as for mine (34)). It worked for me after that.
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 11-28-2014, 11:28 AM #4
    kborgers
    kborgers is offline
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Re: Return next date and sumif error.

    Hello AlKey - thanks very much, that was exactly the issue! I though I was going mad at one point!
    Reply With QuoteRegister To Reply
  5. 11-28-2014, 11:29 AM #5
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Return next date and sumif error.

    Issue 1:
    Your formula criteria is 
    Please Login or Register  to view this content.
    It should be 
    Please Login or Register  to view this content.
    See the difference?! You are using char 148 ”, instead of char 34 "

    Issue 2:
    Enter this in C3 as an array formula (Ctrl-Shift-Enter):
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
  6. 11-28-2014, 11:29 AM #6
    kborgers
    kborgers is offline
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Re: Return next date and sumif error.

    Thanks also to Pepe Le Mokko!
    Reply With QuoteRegister To Reply
  7. 11-28-2014, 11:31 AM #7
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Return next date and sumif error.

    You're welcome and thank you for the feedback!
    Reply With QuoteRegister To Reply
  8. 11-28-2014, 11:32 AM #8
    kborgers
    kborgers is offline
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Re: Return next date and sumif error.

    Thanks Olly!! Perfect solution! Many thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SUMIF by Date - SUMIF by Date = #VALUE when linked worksheet not open
    By alexhartley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2013, 03:56 AM
  2. Sumif for date compare between columns, and return sum of value
    By MPosey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2013, 05:48 PM
  3. [SOLVED] SUMIF(By Date) - SUMIF(By Date)= #Value Error From Linked Data
    By Dragunov in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 11:22 AM
  4. need SUMIF to return error when text is present
    By carsto in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2012, 03:43 PM
  5. Excel 2007 : Formula to return Fri date if M, T, W. Return following Fri date if Thurs or Fri
    By technique17 in forum Excel General
    Replies: 1
    Last Post: 06-30-2010, 04:36 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1