Thread: Summing values in a column if the date in another is of a certain month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
Harvey Coward Harvey Coward is offline
external usenet poster
  
Posts: 6
Default Summing values in a column if the date in another is of a certain month
Thanks, this works a treat.


In message , Bob Phillips
writes


=SUMPRODUCT(--(YEAR(Sheet1!$F$2:$F$200)=YEAR(A1)),--(MONTH(Sheet1!$F$2:$
F$200)=MONTH(A1)),Sheet1!$G$2:$G$200)


--
Best regards
Harvey Coward

Reply With QuoteReply With Quote