SUMPRODUCT Critera - If range values start with number

It's because some of the values begin with a Letter
LEFT(A###,1) = A letter
Letter*Number = #VALUE

Here's an outside the box solution, assuming the numbers are whole numbers, no decimal values.

=SUMPRODUCT((A1:A7>=600000)*(A1:A7<=699999))