CountIFS Formula between two columns

Sinema

Greetings,

I'm probably over thinking this but I'm trying to do the following;

I have a customer account number column and an area column.

I would like to count the total number of unique customer account numbers in [Customer Accounts] that appear in area [Areas]

If I have 20 rows of data and 6 of them have a Customer Account Number (unique to the customer) and all 6 of those appear in [Area] then I would like to count all 6.

The Customer ID is the primary key we use across any database we use so it's the more reliable piece of data to count.

is this possible?

ron.judenberg112096

How about something like:

COUNT(DISTINCT(COLLECT([Customer Accounts],[Areas],area to count)))

Paul Newcome

@Sinema

I agree with @ron.judenberg112096's solution.

=COUNT(DISTINCT(COLLECT([Customer Accounts]:[Customer Accounts], Areas:Areas, "area to count")))

Were you able to get it to work?

Sinema

I'll check it out now, thanks