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?

=SUMPRODUCT((A1:A10="Open")*
(--SUBSTITUTE(0&B1:B10,"-","")=10000)*
(--SUBSTITUTE(0&B1:B10,"-","")<=10999))