There are several ways:

=COUNT(A:A)-SUM(COUNTIF(A:A,{"<200","299"}))
=SUM(IF(ISNUMBER(A1:A100),IF(LEFT(A1:A100)="2",1)) )
=SUMPRODUCT((A1:A100=200)*(A1:A100<=299))

The 2nd formula is an array formula, so press ctrl + shift + enter for it to
work.

HTH
Jason
Atlanata, GA




"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
--
JerryS