Try this, Roc:
http://www.officearticles.com/excel/...soft_excel.htm
Of course, you need COUNTIF instead of SUMIF.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"ROC" wrote in message
...
I want to count the number of Widgets by type in column A (Widget x, Widget
y, Widget z) which were sold on or after 01/01/07 and before 02/01/07