Results 1 to 3 of 3

Counting data from multiple columns without duplicating if data is in the same row

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    17

    Counting data from multiple columns without duplicating if data is in the same row

    Hi,

    I'm wanting to know how many "clients" are in each "category or combination of categories" (signed, sent, prospective). Each column represents the number of contracts/services for each client. It doesn't matter the number, just as long as it's not 0. How do I count "signed" & "sent" without duplicating the count if a client has signed 1 contract, but has another sent?

    Book.xlsx
    Attached Images Attached Images
    Last edited by dgroff; 12-09-2014 at 02:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting data with multiple criteria from different columns
    By Muammar in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-10-2012, 08:24 AM
  2. Counting data in multiple columns
    By Fraukje Coopmans in forum Excel General
    Replies: 4
    Last Post: 10-28-2011, 12:32 PM
  3. counting data in multiple columns on another worksheet
    By fil51773 in forum Excel General
    Replies: 2
    Last Post: 04-07-2011, 10:35 AM
  4. Counting Occurrences of Data in Multiple Columns
    By jgray in forum Excel General
    Replies: 3
    Last Post: 12-13-2010, 03:44 PM
  5. Counting data from multiple columns
    By jamiesda in forum Excel General
    Replies: 3
    Last Post: 03-27-2009, 02:58 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