=SUMPRODUCT((LEFT(E2:E5)="2")*1)
222
0235
00025
00250


number
text
formatted with leading 0's
ans is 1 for the 222

--
Don Guillett
SalesAid Software

"Maxwell" wrote in message
...
You need to be careful when using the LEFT function in this way. While
the numbers are all three digits, some could have leading zeros (if
formatted that way). The LEFT function returns the leftmost
significant digits, and will exclude leading zeros. Therefore, it will
return "2" for either "250" or "024", and potentially overcount your
start-with-2's.

Just my 2 cents.


Seth

On Sat, 11 Jun 2005 05:26:02 -0700, JerryS
wrote:

How do I set up a sumproduct formula to count everything in a column that
starts with the number 2. All of the numbers are 3 digits long. Thanks