Countifs by counting duplicates as one in given date range

[Sekars]

Hello Friends

I need to countifs by counting duplicates as one in given date range in light yellow cell by formula.

thanks in advance.

[Tony Valko]

Try this array formula**:

=SUM(IF(FREQUENCY(IF((B3:B467>=F7)*(B3:B467<=G7),MATCH(C3:C467,C3:C467,0)),ROW(C3:C467)-ROW(C3)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Sekars]

Hello Tony Valko

Thanks for your formula, it is working fine.

Thanks again.

[Tony Valko]

You're welcome. Thanks for the feedback!