ExcelBanter - FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000 (https://www.excelbanter.com/excel-worksheet-functions/88206-formula-counting-s-starting-4-range-1-100-000-a.html)

dbglass

FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000

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

Peo Sjoblom

FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 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.

dbglass

FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,

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.

All times are GMT +1. The time now is 10:55 PM.