CountIFS Formula between two columns



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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!