Hello!

I've a situation that I need to count unique values in collumn D based on criterias on A,B,C and O .


I have made a formula that kinda works. Just the problem is that the formula is so heavy that it freezes my computer every time for like 5 minutes (eventhought I have 8 core i7) and that's just one formula whereas I need 24 of those (2 years)

=SUM(--(FREQUENCY(IF(('Data'!$A$2:$A$200000=D$3)*('Data'!$B$2:$B$200000=D$5)*('AData'!$C$2:$C$200000>=D$6)*('Data'!$C$2:$C$200000<=D$7)*'Data'!$O$2:$O$200000="CE");MATCH('Data'!$D$2:$D$200000;'Data'!$D$2:$D$200000;0));ROW(INDIRECT("1:"&ROWS('Data'!$D$2:$D$200000))))>0))


Is there any way to make the formula lighter. Example how to add extra collum to the data sheet where it displays only unique values from collumn D. Then it would be easy to just use basic Countifs formula.


Thanks in advance.