Formula Help

[gcw]

I currently have a Dept sheet summing the results from different groups. The
items that I need to capture are:

Counting Weekday only
1. How many line items that have closed during the current month and have
closed < 2 weeks of the Open Date,
2. Closed between >2 week and < 4 weeks of open date for current month
3. Closed > 4 weeks of open date of current month.

I have the formula for counting the open and closed, but do not understand
how to count line items that have closed within a current time frame for that
month.

This is my current formula for count “OPEN†line items for month.

=SUMPRODUCT(--(ISNUMBER('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)),--(MONTH('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)=8))

My current formula for count “CLOSED†line items for month is in Column
$G$6:$G$205

Any help on this would be greatly appreciated

 

[Eduardo]

Hi,
try

=SUMPRODUCT(--(ISNUMBER('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)),--(MONTH('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)=8),('[SafetyRegistrationReport.xls]RegisteredItems'!$G$6:$G$205)="CLOSED"))

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Filter by weekday counts between dates.
http://www.mediafire.com/file/myjmhnoyyyj/10_26_09.xlsx