How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)?

The spreadsheet has a column of 2013 expiration dates (column A in m/d/yyyy format), which also includes entries such as "New". Column B contains the 2014 due date (date given once course is completed for next years expiration, there are blank cells) in m/d/yyyy format.

I have tried the following formula that does not work.

```
=SUMPRODUCT((MONTH(R[-70]C:R[-13]C)=2)*(R[-70]C:R[-13]C<>""))--SUMPRODUCT((MONTH(R[-70]C[-1]:R[-13]C[-1])=2)*(R[-70]C[-1]:R[-13]C[-1]<>""))+SUMPRODUCT((MONTH(R[-9]C:R[-6]C)=2)*(R[-9]C:R[-6]C<>""))--SUMPRODUCT((MONTH(R[-9]C[-1]:R[-6]C[-1])=2)*(R[-9]C[-1]:R[-6]C[-1]<>""))
```