|
Formula Help
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 |
Formula Help
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 |
Formula Help
Excel 2007 PivotTable
Filter by weekday counts between dates. http://www.mediafire.com/file/myjmhnoyyyj/10_26_09.xlsx |
| All times are GMT +1. The time now is 02:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com