I have the following formula that generates a #VALUE! error whenever blank lines are included in the range being used. Otherwise it works perfectly.

=SUMPRODUCT(--(DATEVALUE(N7:N100)>$R$12),--(O7:O100))

Column N contains dates whose format needs to be converted with DATEVALUE. Column O contains values.

I have tried the possible solutions below. None have worked and the same error keeps being returned.

=SUMPRODUCT(--(DATEVALUE(N7:N100)>$R$12),--(N7:N100<>""),--(O7:O100))
=SUMPRODUCT(--(DATEVALUE(N7:N100)>$R$12),--(LEN(N7:N100)>0),--(O7:O100))

I do need to consider the possibility of blank lines in the data. So, any help on that?

Thanks in advance,