by using an array formulas in range (E11:E16) According to the above example:

To count unique customers in range (E2:E7) that meet only the following criteria:

1- Purchased Product 1, regardless either they purchased any other products or not

2- Purchased less than 5 units after sum. if there is any repeated customers

3- Their areas codes matche corresponding code in range (D11:D16)

I Use the following array formula to be in E11:

```
=SUM(IF(FREQUENCY(IF($G$2:$G$7=D11,IF($I$2:$I$7="Product1",IF($J$2:$J$7<5,IF($E$2:$E$7<>"",MATCH($E$2:$E$7,$E$2:$E$7,0))))),ROW($E$2:$E$7)-ROW(G2)+1),1))
```

This formula is doing great, at the same time when using it thru very huge database containing tons of rows and columns, excel takes a bout 3 minutes to calculate only one cell which is terrible to continue like that

is there any way to convert this array formula to regular one ... any help will be appreciated to the maximum ... Thanks in advance