Help with a sumproduct formula

[Erick Smith]

Hi, I've been trying without luck to get the following formula to work.

=SUMPRODUCT((A8:A2500>999999)*(A8:A2500<2000000)*(F8:F2500<>"")+(A8:A2500>99
99999)*(A8:A2500<20000000)*(F8:F2500<>"")+(A8:A2500>99999999)*(A8:A2500<2000
00000)*(F8:F2500<>"")+(A8:A2500>999999999)*(A8:A2500<2000000000)*(F8:F2500<>
""))

What I'm attempting to do is count all instances where the entry in A column
is a 7-10 digit number beginning with a "1" and there is number in the F
column. So far my attempts have failed. Does anyone have any quick insight
into what I may be doing wrong?

 

[Don Guillett]

Just apply your logic to the formula to test for a and length and number.
=SUMPRODUCT((LEFT(A2:A200,1)="1")*(LEN(A2:A200)=7)*(ISNUMBER(F2:F200)))

 

[Erick Smith]

Thank you so much... I had a feeling I was going about it all wrong.

 

[Don Guillett]

glad it helped