Get count of items based on 4 variable conditions

Hi Guys,

Please help me on this, I have attached a sample file for explanation, I have 2 sheets, the first one is rods register I put in it,

1. date,
2. rod type,
3. location,
4. status.

what I need in the second sheet " Summary" I to get report about all rods count related to location , status, and number of rods for a certain month which I can choose form cell D3.