Count widgets between two dates - Excel 2003
 

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

Count widgets between two dates - Excel 2003
 

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

Count widgets between two dates - Excel 2003
 

Try this:

=SUMPRODUCT(--(A1:A10="Widget
z"),--(B1:B10=DATE(2007,1,1)),--(B1:B10<DATE(2007,2,1)))

Better to use cells to hold the criteria:

D1 = Widget z
E1 = 1/1/2007
F1 = 2/1/2007

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1),--(B1:B10<F1))

Biff

"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