Results 1 to 6 of 6

Coding a three factor count (presume using a sumproduct function)

Threaded View

bowlerjp Coding a three factor count... 08-12-2019, 11:43 AM
WideBoyDixon Re: Coding a three factor... 08-12-2019, 11:52 AM
bowlerjp Re: Coding a three factor... 08-12-2019, 11:57 AM
WideBoyDixon Re: Coding a three factor... 08-13-2019, 08:17 AM
bowlerjp Re: Coding a three factor... 08-13-2019, 08:32 AM
WideBoyDixon Re: Coding a three factor... 08-13-2019, 08:48 AM
  1. #1
    Registered User
    Join Date
    02-09-2019
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    15

    Coding a three factor count (presume using a sumproduct function)

    I need to count the total number of UNQIUE contracts, split between three categories. I have copied it in below for speed of reference


    Package
    Client1 Bronze 100,000
    Client2 Gold
    Client3 Gold 100,000 100,000
    Client4 Gold
    Client5 Bronze 100,000 75,000 100,000
    Client6 Silver
    Client7 Bronze 100,000
    Client8 Gold 100,000
    Client9 Silver
    Client10 Silver 100,000 100,000 100,000
    Client11 Silver
    Client12 Silver 100,000 100,000
    Client13 Bronze 100,000 100,000
    Client14 Silver 100,000
    Client15 Gold
    Client16 Silver
    Client17 Silver 100,000 100,000
    Client18 Gold 100,000 100,000
    Client19 Bronze
    Client20 Bronze
    Client21 Gold
    Client22 Silver 100,000
    Client23 Gold 100,000 100,000
    Client24 Gold 100,000 100,000
    Client25 Gold 100,000
    Client26 Gold
    100,000



    Total 2 4 6 7 9 10
    Bronze - 1 1 2 2
    Silver 1 1 3 3 5
    Gold 1 2 2 2 2 3

    Hard entered actuals above

    =SUMPRODUCT(N(MMULT(N($O5:U33>0),ROW(INDIRECT("1:"&COLUMNS($O5:U33)))^0)>0))
    I know the above will count total of unique Clients but I want to bring into the sumproduct a way of counting total unique contracts
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count the Maximum contribution factor for every vendor
    By chandramouliarun in forum Excel General
    Replies: 2
    Last Post: 07-01-2019, 07:06 AM
  2. I presume I need a macro
    By DannyBoy2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 01:33 PM
  3. Replies: 11
    Last Post: 01-04-2014, 12:12 AM
  4. [SOLVED] Data miniing with Sumproduct count function
    By coasterman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2013, 02:33 PM
  5. [SOLVED] If function with 3 outcomes. As well as 2nd IF function to factor positive or negitive
    By Danimal615 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2013, 02:36 PM
  6. Conditional Count Using Sumproduct Function
    By Gos-C in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2012, 02:58 PM
  7. Replies: 0
    Last Post: 08-28-2005, 10:54 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