Less "Heavy" Formula

[Joe Galvan]

Hi All,

I have a formula that, due to the amount of rows I have (2K+), takes a long time to calculate. . .

Formula:

{=SUM(IF(FREQUENCY(IF($C$5:$C$9537=$P96,IF($D$5:$D$9537>$R$2,MATCH($H$5:$H$9537,$H$5:$H$9537,0))),ROW($H$5:$H$9537)-ROW($H$5)+1),1))}

Basically the formula counts unique entries, based on 2 criteria points that have to be met.

Any Ideas on how I can make this formula "lighter" but still do the same thing?


thanks...
JOE