Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|