Need a formula for counting all the numbers starting with a 4 within a range
of 1 to 100,000.

One way

=SUMPRODUCT(--(LEFT(A1:A10000)="4"))

or if you meant that the range of numbers can be greater but you don't want
to count numbers starting with 4 that are greater than 100,000

=SUMPRODUCT(--(LEFT(A1:A10000)="4"),--(A1:A10000<=100000))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"dbglass" wrote in message
...
Need a formula for counting all the numbers starting with a 4 within a
range
of 1 to 100,000.

Thank you, it works!
dbglass

"Peo Sjoblom" wrote:

One way

=SUMPRODUCT(--(LEFT(A1:A10000)="4"))

or if you meant that the range of numbers can be greater but you don't want
to count numbers starting with 4 that are greater than 100,000

=SUMPRODUCT(--(LEFT(A1:A10000)="4"),--(A1:A10000<=100000))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"dbglass" wrote in message
...
Need a formula for counting all the numbers starting with a 4 within a
range
of 1 to 100,000.