+ Reply to Thread
Results 1 to 2 of 2

COUNT DISTINCT sumproduct(1/countif(range;range) with condition.

  1. 12-17-2015, 10:49 AM #1
    campelliann
    campelliann is offline
    Registered User
    Join Date
    06-22-2015
    Location
    lisbon
    MS-Off Ver
    windows 8
    Posts
    33

    COUNT DISTINCT sumproduct(1/countif(range;range) with condition.

    Hi I have this problem,

    1 2
    A 1
    B 1
    B 1
    C 2
    B 3

    I need to make a count distinct of the values on the second column IF in the first Column the letter is B. How can I do it?
    Reply With QuoteRegister To Reply
  2. 12-17-2015, 11:22 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: COUNT DISTINCT sumproduct(1/countif(range;range) with condition.

    Try this

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    you may need to replace commas with semi-colon

    Data Range
    A
    B
    C
    D
    1
    Col1
    Col2
    2
    A
    1
    B
    2
    3
    B
    1
    4
    B
    1
    5
    C
    2
    6
    B
    3
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct & Count Distinct
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-26-2013, 12:00 PM
  2. Distinct count of a dynamic range
    By aaanenson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2013, 11:18 AM
  3. [SOLVED] how to use sumproduct count a date range & exclude 7 different words from the range
    By td3601 in forum Excel General
    Replies: 8
    Last Post: 05-14-2012, 02:44 PM
  4. count sumproduct in data range only with condition
    By Armitage2k in forum Excel General
    Replies: 4
    Last Post: 04-19-2012, 11:23 PM
  5. [SOLVED] Excel 2007 : Count the number of Distinct Entries In an auto filtered Range .
    By Red fuji in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 07:06 PM
  6. Counting Consecutive Values in a range but for each occurence a distinct count
    By delhidjinn in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-05-2011, 12:30 PM
  7. SumProduct Formula Count Entries in a range if another range is = 1
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2011, 02:13 PM
  8. Range=Range as condition in Sumproduct
    By osmdian in forum Excel General
    Replies: 1
    Last Post: 08-26-2008, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1