Excel 2007 : Multiple conditionals

[iharri]

Hi, I am trying to work out how I may be able to calculate a formula for the following.

I need to calculate how many cells in a range (I manually specify the range) are equal to OPEN (rather than CLOSED or anything else). I can achieve this with:

=COUNTIF('Risk Log'!Q8:Q16,"OPEN")

BUT I also then need to perform this count only if the month is equal to this month or last month or the month before that etc.

I have columns that are headed Dec, Jan, Feb, Mar, Apr so maybe these values could be used as a reference in the calculations?

I also have a cell in the spreadsheet that represents the current date that I manually enter in this case being 24/03/2010. Maybe this could also be used to derive the desired results?

Your help would be most appreaicted, thanks