Formuladrill

Level 2: Logic and counting Exercise 36 of 118

How many different customers

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Eight orders came from a smaller number of customers. Count how many different customers ordered and put the number in E2. The formula must keep working when the names change.

What this exercise teaches

COUNTA(UNIQUE(range)) is the modern distinct count. In Excel versions without UNIQUE the usual formula is =SUMPRODUCT(1/COUNTIF(B2:B9,B2:B9)), where each customer's rows add up to exactly 1.

A hint if you get stuck

UNIQUE(range) returns the list without repeats. It returns several values, so wrap it in COUNTA to get one number.

Functions used: COUNTA, UNIQUE

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Logic and counting