Need Formula for Calculation and Sorting Matched Words Based on Date

[playaller]

Attached Spreadsheet: Test Agent 2013 Spot Checks.xlsm

I need help with a Error Spot Check excel document for checking errors in processing.

Each month I have to check a agents work for errors.
When checking I have a Userform (Disabled for now) that will fill row A through G per check.

Column C and G are import as:
- Column C: Logs the date the agent did the process
- Column G: Will log the Reason for the Error if there is one

---

I only check for errors 4 weeks (5 business days per week) out of a month so I have a True/False Boolean formula area on the same page starting in columns P6 and Q6 that will determine if I should start checking the first 4 weeks or the last 4 weeks of the month. If the Booleen is True I will start checking the dates for the 1st Monday of the first week followed by the next 3 weeks. If not it will be the date for the first Monday of the second week followed by the next 3 weeks.

---

Finally I have the Error log in Columns I through N that list the matching error reason and the number of errors found for each error type and week but I have to update this manually by hand as I don't know a formula that would match the errors and sum them up by week.

---

There may be a better way you can accomplish this but what I need is:

I need a formula to place in each of the error count cells (Within the Error Log - Columns I though N) that will:

1. First check Column C for the date processed to determine if the erorr (If One) will go within that week
2. Secondly it will check that same row in Column F to determin if Yes there is an error and if so...
3. Third it will check column G to match the reason for the error and..
4. Lastly if the error matches the erorr phrase on the left in column I within the range of the Error type, Sum it up with all the matching errors within the week.

A formula to put in each cell would seem more convenient as I don't know if a macro would be a easy go for this.

I have the spreadsheet but didnt see a way to attach it.

Any help here would be greatly appreciated. Thanks in advance.

[playaller]

Hmm Any thoughts on a starting point for this? I've had no success myself.