Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charting how many widgets over time | Charts and Charting in Excel | |||
Are there any free XL widgets out there ... | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
count dates in excel | Excel Discussion (Misc queries) |