Thread: How do I "Sum sales figure for a finacial month to currenct week"?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How do I "Sum sales figure for a finacial month to currenct week"?
Sorry all, I can use
=SUMPRODUCT((A33:A58=G34)*(B33:B58<=G33)*(D33:D58) )

G34 is Month marker, B is week ending date and D contains data.

Reply With QuoteReply With Quote