View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
 
Posts: 148
Default Subtotal - Based on DATE

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.