12 refers to December in any year.

If you want December of 2007:

=SUMPRODUCT(--(TEXT('Processing'!$J$2:$J1995,"yyyymm")="200712") ,
--('Processing'!$J$2:$J1995<""))



Danny wrote:

Hi,

My formula below retunrs "0" because this year, I think "12" refers to
December 2008. The formula below was to produce December 2007.

Please edit the formula below so it can produce December 2007 and/or
December of ANY year that I will select in the future.

=SUMPRODUCT(--(TEXT('Processing'!$J$2:$J1995,"m")="12"),--('Processing'!$J$2:$J1995<""))

Thank you.

--

Dave Peterson