Results 1 to 8 of 8

SUMIF formuka is giving the incorrect result?

Threaded View

  1. 11-17-2013, 09:20 AM #1
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    SUMIF formuka is giving the incorrect result?

    I have approximately 60 000 rows of product names. Using REMOVE DUPLICATES, I have about 3 000 rows of data. The total units of the 60 000 rows is 349 981 but when I use SUMIF on the unique products, I get 350 067? This does not make sense to me and I would appreciate any insight as to why this could be?
    Thanks in advance.
    Last edited by Aland2929; 11-17-2013 at 10:23 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Similar Threads

  1. [SOLVED] ROUND formula giving incorrect result
    By Marvo in forum Excel General
    Replies: 11
    Last Post: 08-19-2012, 12:15 PM
  2. Array Formulas Giving incorrect value
    By ChemistB in forum Excel General
    Replies: 6
    Last Post: 02-28-2011, 01:16 PM
  3. Giving 1 pt for correct value, 0 for incorrect value, Mac 2004
    By pjk in forum Excel General
    Replies: 0
    Last Post: 09-23-2008, 02:03 PM
  4. Sumif formula not giving result
    By abanerji in forum Excel General
    Replies: 5
    Last Post: 06-13-2006, 02:25 PM
  5. Formula giving incorrect answer...
    By Jambruins in forum Excel General
    Replies: 3
    Last Post: 02-25-2005, 03:06 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