Hi,

=SUMPRODUCT((A1:A10="Open")*(ISNUMBER(--(RIGHT(B1:B10,FIND("-",B1:B1)+1)+0<1000))))

Mike

"hokiebird2008" wrote:

I have a sheet with one column containing either "Open" or "Closed" and
another column with numbers ranging from "09-001" to "10-999". I need to
count the number of entries that are "Open" but only for the numbers ranging
from "10-000" to "10-999". Any suggestions?