In support of this Thread https://excelfox.com/forum/showthrea...ed-on-Criteria
https://excelfox.com/forum/showthread.php/2774-Summarize-Data-from-Dates-to-Months-based-on-Criteria

_____ Workbook: Project Tracker.xlsx ( Using Excel 2007 32 bit )
Row\Col B C D
2 DATE CONTRACT NO. STATUS
3 01-Jul-21 NOT STARTED
4 01-Aug-21 IN PROGRESS
5 02-Aug-21 COMPLETE
6 09-Sep-21 ON HOLD
7 21-Oct-21 NOT STARTED
8 22-Oct-21 IN PROGRESS
9 03-Nov-21 COMPLETE
10 05-Nov-21 ON HOLD
11 12-Dec-21 COMPLETE
12 22-Dec-21 ON HOLD
Worksheet: Case Tracker



_____ Workbook: Project Tracker.xlsx ( Using Excel 2007 32 bit )
Row\Col B C D E F
2 DATE NOT STARTED IN PROGRESS ON HOLD COMPLETE
3 Aug-21
4 Sep-21
5 Oct-21
6 Nov-21
7 Dec-21
8 Jan-22
9 Feb-22
10 Mar-22
11 Apr-22
12 May-22
13 Jun-22
14 Jul-22
15 Aug-22
16 Sep-22
17 Oct-22
18 Nov-22
19 Dec-22
Worksheet: Summary




results after running macro here https://excelfox.com/forum/showthread.php/2774-Summarize-Data-from-Dates-to-Months-based-on-Criteria?p=16306&viewfull=1#post16306 https://excelfox.com/forum/showthrea...ll=1#post16306
_____ Workbook: Project Tracker.xls ( Using Excel 2007 32 bit )
Row\Col B C D E F
2 DATE NOT STARTED IN PROGRESS ON HOLD COMPLETE
3 Aug-21 1 1
4 Sep-21 1
5 Oct-21 1 1
6 Nov-21 1 1
7 Dec-21 1 1
8 Jan-22
9 Feb-22
10 Mar-22
11 Apr-22
12 May-22
13 Jun-22
14 Jul-22
15 Aug-22
16 Sep-22
17 Oct-22
18 Nov-22
19 Dec-22
Worksheet: Summary