I am familiar with array formulas and have used them in several workbooks.

I haven't been able to put together one successfully for a particular purpose. Here is the scenario:

I have one column (column G) which contains numbers. This entire column is also named "Age_in_Days". In another column (L) I have dates. Column L is also named "Complete".

I need a formula that counts the cells in column G that are greater than 180 and occured during the month of October 2009.

The issue, as I see it, is that I have can't seem to get the formula to recognize a range of dates that all occur within October 2009.

Any help would be greatly appreciated.