Thread: sumproduct including previous years
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tleehh tleehh is offline
external usenet poster
  
Posts: 21
Default sumproduct including previous years
=sumproduct(d18:d1000,--(year(b18:b1000)=year(now())))
I need a formula to add all the values in d18:d1000. All the previous years
including current year.
Reply With QuoteReply With Quote