ExcelBanter - Counting dates with conditions

Take a look farther down, this page, for the Gooders question.
Micky

"Saylindara" wrote:

I have been counting the number of appointments that were sent for
referrals received in each month, e.g. for the sample below it would be 2
August and 1 for September. I have successfully been using this formula:

=SUMPRODUCT(--(MONTH(A2:A10)=cell reference with
month-year),--(ISNUMBER(B2:B10)))

This has been so successful I want to continue it for next year. Is there
some way I can include the year in the formula.

Referral received Appointment sent
3/8/09 31/8/09
4/8/09 2/9/09
5/8/09
2/9/09
3/9/09 4/9/09
5/9/09