Require Help with Counting based on multiple Criteria (array)

I've attached a worksheet that more clearly explains the problem. I have one sheet with records in a line list format. A second sheet that is for summary purposes.

A record may or may not contain the word "Critical" in one column, but it will certainly have a date and a site reference.Each incident gets its own record, so one site may have several records for a single day, each containing the word critical.

The summary sheet has the last 30 days in a row across the top. The first column is the name of each community. I want to count the number of critical incidents, for each site, for each day, and display them. Something like this:

Site****Apr15 | Apr14 | Apr13 | Apr12 | Apr11 | Apr 10
Alpha** 0 | 0 | 1 | 0 | 2 | 3
Beta*** 1 | 2 | 0 | 0 | 0 | 0


To solve this problem I have tried using sumproduct, sumproduct in an array, sum(if(if formulas, and lately, vlookups, though I can't imagine how those might work.

Hoping someone can help my break through this "writer's block".