Countif problem with N/A

[winrz]

I have this formula which looks at the dates in column N and compares it to another, column M. It does a good job at telling me how many entries there are for Jan, how many for Feb, etc..

what I cant figure out is as soon as someone puts a "N/A" into the date column N, this formula chokes.. I cannot figure out how or where to put an IF statement to look for the "N/A" and disregard it.

=SUMPRODUCT((MONTH($N$17:$N$25)=MONTH(M17&0))*(YEAR($N$17:$N$25)=$J$2))

N = column input for month and year
M = column that houses the 12 months to compare against
$J$2 = 2004

 

[winrz]

Aladin, THATS IT! I havent figured out its logic, but its simple, and does the job.

Thank you guys. Thank you.

I still think there should be some sort of payback in all of this - like posting your Amazon wish list or something.

TW