Count widgets between two dates - Excel 2003

[Guest]

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

 

[Anne Troy]

Try this, Roc:
http://www.officearticles.com/excel/sumif_with_dates_in_microsoft_excel.htm

Of course, you need COUNTIF instead of SUMIF.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[T. Valko]

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