+ Reply to Thread
Results 1 to 5 of 5

Formula not calculating correctly?

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Formula not calculating correctly?

    Hi,

    I have been using this formula in the past and it has worked but when i try and do it with the attached it does not bring back a true value. Basically i have a list of sale dates, value and live date, in the formula i have asked it to look at a specific month and identify the total value of live dates within the given year range. It does not seem to bring back the correct value, can anyone help me on this issue please and explain where it may have gone wrong?

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,646

    Re: Formula not calculating correctly?

    Sale date is in column A and live date in column C?

    You want to add up values with a sale date in July that meet what criteria????
    Glenn



  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,646

    Re: Formula not calculating correctly?

    Quote Originally Posted by Dooberry View Post
    identify the total value of live dates within the given year range. [....] can anyone help me on this issue please and explain where it may have gone wrong?
    In G8, for example, you have:

    =SUMIFS($B$2:$B$117,$C$2:$C$117,">="&$H$3,$B$2:$B$117,"<="&$I$3)

    I think that should be:

    =SUMIFS($B$2:$B$117,$C$2:$C$117,">="&$H$3,$C$2:$C$117,"<="&$I$3)

  4. #4
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Formula not calculating correctly?

    Hi,

    Sorry if i was a bit vague in the description of request. The first column has sale dates, the column with revenue value is the sale value and the final column has go live dates. I am trying to choose each month range be it, Jul, Aug, Sep etc and have the revenue amount total up for sales that go live within a financial year of Jul15-Jun16.

  5. #5
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Formula not calculating correctly?

    joeu2004 I think this may have fixed it, thanks. I was suprised i didn't notice that as i have had this working plenty of times prior to this report. Thanks again.

+ 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. [SOLVED] Formula not calculating correctly
    By ratboyab in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-29-2013, 06:35 PM
  2. Total sum formula not calculating correctly
    By SHEFFCOURT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-07-2013, 11:12 AM
  3. Formula not calculating correctly
    By mgfuentes in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-09-2012, 01:21 PM
  4. Formula not calculating correctly
    By Whittle82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2012, 05:54 PM
  5. Excel Not Calculating Formula Correctly
    By Njisom13 in forum Excel General
    Replies: 2
    Last Post: 12-27-2010, 07:38 AM
  6. Formula Not Calculating Correctly
    By be965 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2007, 03:30 PM
  7. [SOLVED] figure out why this formula isn't calculating correctly
    By Dave F in forum Excel General
    Replies: 10
    Last Post: 09-01-2006, 05:47 PM
  8. Simple formula not calculating correctly
    By LeighG in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 11:22 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