+ Reply to Thread
Results 1 to 7 of 7

Sumproduct Formula - Returning result in two diffent places for same entry?

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Sumproduct Formula - Returning result in two diffent places for same entry?

    It's make me add a comment to show solved?
    Last edited by SVTF; 09-09-2015 at 07:58 PM. Reason: Solved

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Sumproduct Formula - Returning result in two diffent places for same entry?

    That is a pretty complex file you have there.

    I am puzzled as to why you convert real dates to 6-digit numbers? This seems to make trouble-shooting extra complex
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342
    Done because of the way the raw report data comes in.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Sumproduct Formula - Returning result in two diffent places for same entry?

    Hi.

    I can't find a yellow-highlighted cell of relevance in here? Perhaps it would be better to let us know the actual sheet/cell references of interest.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  5. #5
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342
    In the column with dates between Aug 17 and Aug 23 under passive. The 1 should not be there. For some reason it is there b re cause it is counting the entry on the cases tab dated 20150904 twice?

  6. #6
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342
    In the column with dates between Aug 17 and Aug 23 under passive. The 1 should not be there. For some reason it is there b re cause it is counting the entry on the cases tab dated 20150904 twice?

  7. #7
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342
    Solved

    It the date refference I had 2018.

    Will mark as solved when I get home.

+ 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] Why is this formula returning a FALSE result? It should return the value in B13
    By golfpromal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-20-2012, 05:22 PM
  2. [SOLVED] Returning the cell above a vlookup formula result
    By mike_vr in forum Excel General
    Replies: 3
    Last Post: 05-16-2012, 07:34 AM
  3. Prevent Formula Returning Negative Result
    By Manic in forum Excel General
    Replies: 2
    Last Post: 11-09-2011, 11:27 AM
  4. Sumproduct Formula Returning a Strange Result
    By Steve Collins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2010, 11:07 AM
  5. VLookup formula returning an incorrect result
    By Spiritseeker in forum Excel General
    Replies: 2
    Last Post: 03-23-2010, 07:51 AM
  6. Simple formula returning odd result
    By tonywig in forum Excel General
    Replies: 3
    Last Post: 06-10-2009, 07:37 AM
  7. Formula result returning #n/a
    By Ulaw in forum Excel General
    Replies: 3
    Last Post: 10-21-2008, 05:34 AM
  8. Index formula returning incorrect result
    By Nadir Soofi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2008, 02:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1