+ Reply to Thread
Results 1 to 3 of 3

Count Unique Values Based On Two Criteria - how do I update this formula?

  1. #1
    Registered User
    Join Date
    02-15-2016
    Location
    London, UK
    MS-Off Ver
    14
    Posts
    32

    Count Unique Values Based On Two Criteria - how do I update this formula?

    Hello,


    I have a formula that counts unique values based on one criteria, but I need to update it to count unique values based on two criteria. Please help!
    Attached is the example: In column H I have applied formula to count uniq number of bottles, but now want to add one ore criteria which is now many used unique bottles there are. How do I amend current formula to give me the outcome like in column F?


    Many thanks!
    J.
    Attached Files Attached Files
    Last edited by JuNova; 04-29-2018 at 10:06 PM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,620

    Re: Count Unique Values Based On Two Criteria - how do I update this formula?

    Try this:

    =SUM(IF(($A$2:$A$8=E4)*($C$2:$C$8="Yes"),1/COUNTIFS($A$2:$A$8,$A$2:$A$8&"",$B$2:$B$8,$B$2:$B$8&"",$C$2:$C$8,"Yes")))

    Array formula, enter with Ctrl+Shift+Enter.

  3. #3
    Registered User
    Join Date
    02-15-2016
    Location
    London, UK
    MS-Off Ver
    14
    Posts
    32

    Re: Count Unique Values Based On Two Criteria - how do I update this formula?

    It worked! Thank you ))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique (text) values based on two criteria
    By Gijs in forum Excel General
    Replies: 4
    Last Post: 03-09-2018, 07:50 AM
  2. [SOLVED] Count Unique Values based on 2 criteria
    By spyac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2018, 01:04 AM
  3. count unique values based on between dates with a criteria
    By FUN2BALA in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-22-2017, 04:55 AM
  4. Using sum if frequency to count unique values based on certain criteria
    By Matthew_Smith86 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-08-2015, 05:27 AM
  5. [SOLVED] Count unique values based on criteria but without array formula (CSE)
    By Villalobos in forum Excel General
    Replies: 3
    Last Post: 05-09-2015, 05:05 AM
  6. Count unique values based on several criteria
    By evilgrin in forum Excel General
    Replies: 2
    Last Post: 10-10-2010, 03:50 PM
  7. [SOLVED] how to count unique values in excel based on criteria
    By Jorge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2005, 10:06 AM

Tags for this Thread

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