Summing numeric values in a row that contains both numbers and dates

Or more correctly, assuming that all your dates are after the year 2000, you may try this.....

=SUMPRODUCT(--(A1:N1<>""),--(YEAR(A1:N1)<2000),A1:N1)