Thread: OFFSET function to pick up monthly groups of data
View Single Post
  #3   Report Post  
Gary T
 
Posts: n/a
Default
Not to worry, I got it:


In cell C6 I put:

=SUM(OFFSET(Daily!$C7,0,IF(ISNUMBER(B2)=FALSE,0,EO MONTH(B2,0)+1-$C$2),1,(EOMONTH(C$2,0)-C$2+1)))

Gart T.
Reply With QuoteReply With Quote