Hi everyone,

I have a frequency formula in an array:

=SUM(IF(FREQUENCY(IF(LEN(Data!K488:K520)>0,MATCH(Data!K488:K520,Data!K488:K520,0),""), IF(LEN(Data!K488:K520)>0,MATCH(Data!K488:K520,Data!K488:K520,0),""))>0,1))

And I have a column J that has corresponding dates beside column K. I would like to have the formula spit out a value that is based on a customizable date range. That is, expand K488 and K520 (say K5 to K 600) and have a sumproduct or some other formula which makes the array look at column J and 2 dates in 2 other cells, so that it is customizable for that date range.

If I wasn't clear, please let me know. Any help is greatly appreciated.

Thanks