Countif, Max If, Sumif with date

I have three issues

1. Highlighted in pink - I am working in Excel 2003 which doesn't have countifs. I want to count the cell that are in district 1 and are resolved. Can countif be nested or can I get the results with an if statement?

2. Highlighted in orange - I came up with a formula to get an average but I want to have it average just records from the last 6 months. What do I need to add to this formula? =SUMIF(FY11District,$A8,FY11RDaysOut)/COUNTIF(FY11District,$A8)

3. Highlighted in yellow - Trying to get Max and Min number that meet a criteria. Can't find a formula that will do that.

Thanks for your help and direction.