2-dimensional Date Range Criteria

Attached is a really simplified version of what I'm trying to accomplish. I'll attempt to get my brain working well enough to explain it:

For each row, I have a person's name, their department, their site, and then a series of dates (representing dates of attendence). The four columns after the dates ("Counts" is the first) are me trying to keep all the right numbers in mind, and are the routes I've been trying to take on this. I have also tried to make a custom formula called ClassInRange, which isn't playing nicely.

What I eventually need to populate is the little 2x3 section at the bottom where the three sites and the two departments I'm working with (down from 5 sites and 8 departments for the sake of sanity). What I need to be able to do is populate those cells with something that will tell me how many people from which site and department have attended something within the date range.

So, for example, I need to know that the 2 guys in Wellesley attended something between January 1st and December 31st of 2007. (American date style, in case anyone's lost)

If you're able to help, please keep in mind that I'm not the end-user; I'm just the slightly crazy dude trying to create this thing and make it simple to use. Eventually, the Dept/Site box will be part of a template which is copied and pasted up to four times on a report sheet, each fed by different date-range criteria.

Also, the important information is the person's name, dept and site, which I hope gives some reason behind the organization; we want to find the person easily.

• 2-dimensional Date Range With Dynamic Copy And Paste
• Creating A 2-dimensional Array From A 1-dimensional List
• Bi-dimensional Dynamic Range
• Next Date Matching Criteria Within Date Range
• Fill Range From Multi-dimensional Array
• Date Range With Other Criteria
• Using A Date Range As Criteria
• Lookup 2 Different Criteria Then Average Between A Date Range
• IF Then, Two Criteria, Date/Time Range Formula
• Multiple Criteria Lookup With Date Range Match
• Count Between Date Range & Text Criteria
• REcord That Fall Within Date Range, AND Meet Text Criteria
• Microsoft Query :: Put Floating Date Range In Criteria
• Sum Range Based On Dates In Another Meeting Date Criteria
• Copy Range & Paste Based On Date Criteria
• COUNTIF: 2 Criteria: Date Range Column & Text Column
• Dificult Sum + Sum.if Date Range Criteria
• Sum Range Based On 1 Criteria Of Column & 2 Criteria Of Another
• Date Range: Reference A Single Date And Output Date Ranges
• Dimensional Table
• Macro – Two Dimensional Look Up
• SUM Of Values In 1 Range Based On Specific Criteria In Another Range
• Dimensional Weight Formula
• Dimensional Weight Formula II
• Interpolate Two-dimensional Array
• Function For 2-dimensional Array
• Sum Range Using 1 Column Of Named Range As Criteria
• Summing In A Multi Dimensional Array
• Multi-dimensional Array Solution
• Populating A Multi-dimensional Array
• Double Lookup From Two Dimensional Table
• Checking If Variable Is Multi-dimensional
• Filling All Elements Of A Two Dimensional Array?
• Fill ComboBox With 2 Dimensional Array
• Data Type Of Coordinates Of 2-dimensional Array
• Evaluate Multi-Dimensional Array Matrix
• Multi-dimensional Array Not Showing In Listbox
• Join Dynamic Multi-dimensional Array
• Assign Listbox Values To Two Dimensional Array
• Performing Worksheet Functions On One Column Of A Two Dimensional Array?
• Fill & Rearrange Multi-dimensional Array From Another
• Compare Dates To Date Range & Return Date Based On Outcome
• Fill Table Based On Another Within Date Range & Cut Off Date
• Formula For Determining If Two Date Columns Fall Within Specific Date Range
• Lookup Values From A Multi Dimensional Table / Data Sheet
• Two-Dimensional Pull The Amount It Will Payout (based On The Place And The # In Class)
• Restrict Date Entry To Be With Date Range/Scope
• Find Start Date And End Date In Range
• VBA To Generate Row For Each Date In Date Range
• Delete Rows If Cell Contains Date Outside Date Range