Thread: Trying to find out a solution for a complex formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Trying to find out a solution for a complex formula
In your "main flash" sheet:

=SUMPRODUCT(actuals!B1:B100,actuals!A1:A100=B1-6,actuals!A1:A100<=A1)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote