Is it possible to create a summary report?

I have never used excel as a base for a report. Normally I use Access. Is it possible to create a summary report in excel?

(See the attached excel sheet.)

If it is what I am trying to do is make a weekly report of inspections that are outstanding. I know this will not be a simple task but I need direction on where to start.

I'd like to have something like this:

Week ending 11/14
Bldg CO0533 - 2 incomplete
Bldg CO0627 - 1 incomplete
Bldg CO1572 - all completed
Bldg CO1917 - 2 incomplete