Results 1 to 15 of 15

SUMIF Date Formula not calculating correct total

Threaded View

  1. 04-04-2017, 06:15 PM #1
    SamCaunt
    SamCaunt is offline
    Registered User
    Join Date
    04-04-2017
    Location
    Barnsley
    MS-Off Ver
    2011
    Posts
    7

    SUMIF Date Formula not calculating correct total

    Hello Everyone,

    I have come here for some advice, im normally ok with Excel formulas but this has bambooozled me...

    The formula works when i keep the date ranges between say for example 21.03.2017 and 31.03.2017

    When i change the start date to 01.03.2017 and end date to 31.03.2017 it comes up with an invalid total.

    It seems to be when i change the start and end dates to outside my criteria... (if that makes sense)

    Ive attached the worksheet as an example could someone help me please.

    The link to my file is https://ufile.io/f28a2
    Last edited by SamCaunt; 04-04-2017 at 06:21 PM.
    Reply With QuoteRegister To Reply
« 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. Using SUMIF to sum total values within a date range specified by the date minus
    By essjays in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-20-2015, 11:46 PM
  2. Is SUMIF the correct formula to use for this?
    By Linnylops in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2015, 06:58 AM
  3. Using a SUMIF formula and not sure if this is correct
    By Barry83 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2014, 03:30 AM
  4. [SOLVED] Month formula not calculating correct
    By hkyomha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 03:04 PM
  5. sumif returning correct total while sumifs returns #value
    By mlevitt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2013, 04:16 PM
  6. Excel 2007 : Formula does not give correct Total.
    By msladona in forum Excel General
    Replies: 5
    Last Post: 01-30-2010, 05:32 PM
  7. Which formula is correct for calculating times?
    By djm in forum Excel General
    Replies: 3
    Last Post: 05-07-2006, 07:58 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