CODEWITHSUNDEEP
google-sheetsfilteruniquecountingcountif
Chris Rosendin
Chris Rosendin

Reputation: 367

How to count unique values in one column based on two separate columns in sheets

sample data

For each account, I want the total number of unique customers that purchased "Tech1." My data is on one tab and the unique account list is on another.

I can get the number of rows that match the account and contain "Tech1" with this: =countifs($A$2:$A$30,$E2, $C$2:$C$30,"*Tech1*") But I can't figure out how to count each customer that contains the target product only once.

Upvotes: 1

Views: 83

Answers (1)

player0
player0

Reputation: 1

try

=COUNTUNIQUE(IFERROR(FILTER(B:B, A:A="xxx", REGEXMATCH(C:C, "Tech1"))))

0

Upvotes: 2

Related Questions