Summarize data based on multiple criteria

I have a worksheet with several columns of data that I have to summarize elsewhere on the sheet. Here are the columns:

ID
Status
Joined
Name

Name can take on 4 possible values. For each value in Name, I want to count the number of cells in a column that fit certain criteria. Here are the counts I want to make:

Status OK: Status is a date.
Joined OK: Status is a date and Joined is a "1".

There are going to be about 500 records to count. I've already implemented these counts in a Windows scripting language that interfaces with Excel, but I know there must be a more direct and faster way to do it entirely in Excel, whether with VBA or writing functions into cells.

I have attached a copy of the sheet with sample data on it.