Steve -
You can use the SUMPRODUCT function to do a multi-criteria count. The
trick is when you use the LEFT function, the result is a text string so
you must convert the numerical criteria to text.
Assuming original "numbers" are in column S, the resulting leading
numbers (as text) are in column X and the other criteria in Y....

=SUMPRODUCT(--(X1:X100="1"),--(ISBLANK(Y1:Y100))

To avoid the "1" business, change your formula in column X to
=VALUE(LEFT(S74,1)) to create a number value instead of a text value.

You might consider this variation to eliminate the need for column X...

=SUMPRODUCT(--(LEFT(S1:S100,1)="1"),--(ISBLANK(Y1:Y100)))


- John Michl