Thread: YTD SUMIF based on current date
View Single Post
  #2   Report Post  
garygoodguy garygoodguy is offline
Junior Member
  
Posts: 29
Default
Thanks anyway. Have figured it out from another forum.
Answer for those interested:

=SUM("start of data range":INDEX("start of data range:end of data range,MATCH(dropdown list with months,start of month range:end of month range,0)))
Reply With QuoteReply With Quote