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

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

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"))


"gcw" wrote:

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

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

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