Thread: =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
Try similar to this:
=SUMPRODUCT(--(MONTH(Sheet1!$A$3:$A$31)=MONTH(Sheet1!A3)), --
(YEAR(Sheet1!$A$3:$A$31)=YEAR(Sheet1!A3)))

Change sheet name and ranges to suit.

Hth,
Merjet
Reply With QuoteReply With Quote