+ Reply to Thread
Results 1 to 10 of 10

Sumifs problem

  1. #1
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Sumifs problem

    Hello,

    I have sumifs problem and I do not know what is the reason. I assume the problem is the date format because if I type manually the date on sheet1 then formula on sheet2 is working fine. The formula on sheet2 is calculate the amount in the actual month regarding the material number. Please note that on sheet1 and sheet2 there are more thousand data lines.

    The data (on sheet1) coming from directly from my ERP system.

    Please Login or Register  to view this content.
    Do you have any idea what could be the solution?

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Sumifs problem

    Don't know what is your actual problem???

    Since everything is working fine for me


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Sumifs problem

    Hi,

    The Date Values on Sheet 1 F Column, are incorrect... You might want to check that out..

    It will work then
    Cheers!
    Deep Dave

  4. #4
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Sumifs problem

    yes, the date value is my problem. Could you please tell me how is it possible to change in mass for that the formulae on sheet2 working fine? I can not figure out.

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Sumifs problem

    Here!

    Use this formula on cell J10 and drag down, and then Paste Special the newly derived values on range F10:F14

    =DATE(LEFT(F10,4),MID(F10,4,2),RIGHT(F10,2))

  6. #6
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Sumifs problem

    The formula is turn to #Value! error.
    Do you have any idea how should to do this in the above mentioned code?
    Attached Files Attached Files

  7. #7
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Sumifs problem

    Its working at my end as soon as I open the file..

    Changed the formula a bit though..
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Sumifs problem

    hmmm... it is strange on my side the date is 25 May 2015 instead of 25 Feb 2015 in cell J10

    Is this the same at your side?

  9. #9
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Sumifs problem

    I am sorry.. My Fault!

    Put this in Cell J10

    =IF(ISNUMBER(F10),F10,DATE(LEFT(F10,4),MID(F10,6,2),RIGHT(F10,2)))

    Sorry for the trouble!

  10. #10
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Sumifs problem

    Thank you help, please receive my rep!

+ 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 problem
    By soul24rage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2014, 11:34 PM
  2. Problem with SUMIFS
    By SharpL in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-27-2014, 08:07 AM
  3. Sumifs problem
    By kim296 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-02-2013, 02:56 PM
  4. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  5. SUMIFS Problem
    By denise001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2011, 08:38 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