Hello all!

I'm trying to count the number of records I have that are 6 characters long and begin with a 6.

I using SUMPRODUCT at the moment, but I'm having issues with the text strings (technically, all values are stored as text).

I've got just under a million rows, so helper column / filter won't work because this locks up Excel.

	A	B	C
1	H12345	
2	668958
3	612385
4	604
5	8294
6	632868
7	ABC818

=SUMPRODUCT((LEN(A1:A7)=6)*(LEFT(A1:A7,1)*1=6))

The second half of this is where my logic falls apart. The strictly text rows evaluate to #VALUE and I'm not sure how to circumvent this.