Thread: Getting sum of values in another sheet while using condition
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
  
Posts: 151
Default Getting sum of values in another sheet while using condition
Let's assume

A1 = Start Date
B1 = Finish Date

=SUMPRODUCT(--(Sheet1!$A$2:$A$1000=$A$1),--(Sheet1!$A$2:$A$1000<=$B$1),Sheet1!$B$2:$B$1000))

HTH
Mick.
Reply With QuoteReply With Quote