## 2 Answers

If you just want to count the **different** order numbers (in column B) that are complete (column A) try this

`=SUM(IF(FREQUENCY(IF(A$2:A$100="Complete",MATCH(B$2:B$100,B$2:B$100,0)),ROW(B$2:B$100)-ROW(B$2)+1),1))`

confirmed with CTRL+SHIFT+ENTER

To add another condition, e.g. assuming status in A and Store Id in B as before but with Sales Reps in column C you can use this version

`=SUM(IF(FREQUENCY(IF(A$2:A$100="Complete",IF(C$2:C$100="Rep1",MATCH(B$2:B$100,B$2:B$100,0))),ROW(B$2:B$100)-ROW(B$2)+1),1))`

of course you can use cells to store the criteria if you wish

2

I think, you are looking for this output:-

- Click
`Data`

- Click
`Advanced`

from`Sort & Filter`

- Do as per my screenshot
- Result will be at
**F and G Columns**

## Update:

Count the unique cells,

```
=SUM(IF(FREQUENCY(B:B,B:B)>0,1))
```

**Result:**

6

**Example Data:**

```
A B
thank you 941000106879
complete 941000106879
complete 941000106879
complete 941000107445
complete 941000107445
complete 941000107445
complete 941000107445
complete 941000107446
complete 941000107447
complete 941000107451
complete 941000107451
complete 941000107451
complete 941000107451
complete 941000107451
complete 941000107456
complete 941000107456
complete 941000107456
complete 941000107456
```

5

-1