Results 1 to 20 of 20

Sum column exclude duplicates

Threaded View

ryan@csi Sum column exclude duplicates 11-13-2009, 04:51 PM
JBeaucaire Re: Sum column exclude... 11-13-2009, 05:34 PM
ryan@csi Re: Sum column exclude... 11-13-2009, 05:37 PM
ryan@csi Re: Sum column exclude... 11-16-2009, 09:49 AM
NBVC Re: Sum column exclude... 11-16-2009, 10:23 AM
ryan@csi Re: Sum column exclude... 11-16-2009, 11:07 AM
NBVC Re: Sum column exclude... 11-16-2009, 11:08 AM
ryan@csi Re: Sum column exclude... 11-16-2009, 02:14 PM
NBVC Re: Sum column exclude... 11-16-2009, 02:27 PM
ryan@csi Re: Sum column exclude... 11-17-2009, 12:23 PM
NBVC Re: Sum column exclude... 11-17-2009, 12:42 PM
ryan@csi Re: Sum column exclude... 11-17-2009, 01:09 PM
NBVC Re: Sum column exclude... 11-17-2009, 01:21 PM
ryan@csi Re: Sum column exclude... 11-18-2009, 09:56 AM
ryan@csi Re: Sum column exclude... 11-18-2009, 01:12 PM
NBVC Re: Sum column exclude... 11-18-2009, 01:25 PM
NBVC Re: Sum column exclude... 11-18-2009, 01:16 PM
ryan@csi Re: Sum column exclude... 11-18-2009, 01:29 PM
NBVC Re: Sum column exclude... 11-18-2009, 01:29 PM
ryan@csi Re: Sum column exclude... 11-18-2009, 02:40 PM
  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    SC
    MS-Off Ver
    Excel 2003
    Posts
    22

    Sum column exclude duplicates

    I've got data for different regions of our company. For this example, what I need to do is count the number of jobs in the "South Atlantic" region (Column T) that are NOT "Wal-Mart Stores, Inc" jobs. In order to do this, I put a "1" in Column F so that the formula would have something to sum:

    =SUMPRODUCT(--(T2:T1079="SOUTH ATLANTIC"),--(H2:H1079<>"WAL-MART STORES, INC"),(F2:F1079))

    The problem is that some job numbers, which are located in Column G, are duplicated. As a result, this number is higher than it should be.

    So what I need to do is only count each job number once. How do I do that? Is there a way to modify the existing formula? Or do I need something completely different?
    Last edited by ryan@csi; 11-19-2009 at 01:02 PM.

Thread Information

Users Browsing this Thread

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

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