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,
Bookmarks