add IF stmt to a Count unique?

[dbwiz]

Col H containes text in some of the rows, Col I there are dates in all the rows. I need to count the unique dates in Col I - IF Col H is not blank.

This is what I have for Col I (which has to have CTRL-Shift-Enter after pasting to get it to put {} around it to "take." How can I add an if statement to this - or is there a simpler way?

=SUM(IF(LEN(A2:A4970),1/COUNTIF(A2:A4970,A2:A4970)))

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($I$2:$I$4970<>"",IF(1-($H$2:$H$4970=""),
    MATCH($I$2:$I$4970,$I$2:$I$4970,0))),
       ROW($I$2:$I$4970)-ROW($I$2)+1),1))

 

[dbwiz]

Thank you!

 

[Aladin Akyurek]

Thank you!

You are welcome. Thanks for providing feedback.