Search
Search

Using Countifs to count distinct values and multiple criteria?

Sean Published at Dev
25
sean

I am trying to count how many brands a certain client has passed through. I essentially have two columns a client list and a brand column.

In some cases, there may be duplicates of the brand so I only need to count them once.

I have tried to use several variants Countifs/Sumifs formulas but to no success.

Totally lost and would appreciate any help Example

Thanks

n8-da-gr8

Try: =SUMPRODUCT(--(COUNTIFS($A:$A,$D2,$B:$B,$H$1:$H$10)>0))

enter image description here

You'll need to make a helper column which contains all the brands (no duplicates). The only thing that should change in the formula is $D2, which is the Client in question. So it will become $D3, $D4, etc.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Using sumproduct and countifs to find unique values that match a criteria

Multiple Values using single Criteria

Return multiple COUNT fields for distinct values per a unique ID based on two criteria conditions

Impala: count(distinct) with multiple where statement criteria?

COUNTIFS with multiple criteria and with OR condition

Excel - Count unique values that meets multiple criteria

How to count multiple distinct values?

Getting distinct values using tiered criteria

How to use countifs function to count multiple criteria involving dates?

Countifs with multiple OR criteria ranges

Sum of COUNTIFS with multiple OR criteria and AND

Excel COUNTIFS with multiple criteria

Excel – using multiple criteria in COUNTIFS function

CountIfs with Multiple Criteria?

Counting Distinct Values with multiple criteria

Count distinct values in multiple columns

VBA CountIFS With Multiple Criteria

CountIFS function with multiple criteria and values

Excel COUNTIFS multiple and sequential criteria

COUNTIFS: Calculating percentage with multiple criteria

Using Excel TextJoin in conjunction with a Countifs() with multiple criteria

COUNTIFS with multiple Ranges, Single Criteria

Count distinct values based on multiple criteria

Distinct count using countifs in excel

TSQL : Count distinct values overall and based on criteria by group

COUNTIFS Multiple Criteria and ignoring blanks values

How to DISTINCT COUNT with multiple criteria in BIGQUERY

Countifs using multiple dynamic arrays as criteria

count distinct multiple values in XQuery

TOP Ranking

  1. 1

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  2. 2

    pump.io port in URL

  3. 3

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  4. 4

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  5. 5

    How to use HttpClient with ANY ssl cert, no matter how "bad" it is

  6. 6

    Modbus Python Schneider PM5300

  7. 7

    What is the exact difference between “ use_all_dns_ips” and "resolve_canonical_bootstrap_servers_only” in client.dns.lookup options?

  8. 8

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  9. 9

    BigQuery - concatenate ignoring NULL

  10. 10

    split column by delimiter and deleting expanded column

  11. 11

    Unable to use switch toggle for dark mode in material-ui

  12. 12

    Soundcloud API Authentication | NodeWebkit, redirect uri and local file system

  13. 13

    Apache rewrite or susbstitute rule for bugzilla HTTP 301 redirect

  14. 14

    Is there an option for a Simulink Scope to display the layout in single column?

  15. 15

    UWP access denied

  16. 16

    Center buttons and brand in Bootstrap

  17. 17

    express js can't redirect user

  18. 18

    Make a B+ Tree concurrent thread safe

  19. 19

    Printing Int array and String array in one

  20. 20

    Google Chrome Translate Page Does Not Work

  21. 21

    Elasticsearch - How to match number range in string

HotTag

Archive