Hi all,

I'm trying to count the number of rows in a worksheet list that have two
conditions. One of the rows is formated as a date and I need to convert that
to a month number prior to the '=' sign in that condition. I tried this:

=SUMPRODUCT('MyOtherWorksheet'!N2-N81="Yes")*(Month('MyOtherWorksheet!k2-k81)=2))

I'm getting a 'value' error which must be from the part trying to convert
the date column into month numbers.

Any suggestions?

Thanks,
CW