Multi Criteria Countif
numbers ranging from "09-001" to "10-999".
Use cells to hold the criteria.
D2 = Open
E2 = 10-000
F2 = 10-999
=SUMPRODUCT(--(A2:A20=D2),--(B2:B20=E2),--(B2:B20<=F2))
--
Biff
Microsoft Excel MVP
"hokiebird2008" wrote in message
...
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?
|