Results 1 to 4 of 4

Thread: SumIF within date range over multiple months/years

  1. #1
    Neophyte davenmarc's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    2010

    SumIF within date range over multiple months/years



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good Evening All

    I am struggling to get the totals to add up to what it should be. It is using SUMIF formula with between dates formula. If i use dates from A1:A8 as in the example i have. It totals the correct amount
    If i use dates A1:A31 it gives some absurd answer.

    Because the first test gives the correct answer i dont think the issue is with my formula but it lies with the date format or how excel reads the date as it is failing to read the dates correctly from what i can tell.

    I would appreciate any help with regards to this please if possibleExcel upload booklet.xlsx

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    None of the dates are actually dates - they are text. If they were dates, and you set the cell formattin to General, they would show as a 5-digit serial number starting with 3.

    You need to change all the dates from text to date - just selecting the formatting does NOT change the type of data in the cell. You should be able to use Text to Columns on the Data ribbon to make the changes necessary.
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte davenmarc's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    2010
    Hi AligW

    Thank you so much for the info and correction. I am able t get it working now. Thanks again =)

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    My pleasure.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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