View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via sarpi via sarpi is offline
external usenet poster
 
Posts: 10
Default help with Sum in between dates

thanks really a lot....BUT it doesnt work.

take for example the Project "C".
your formula dont get it, since its start-year is before our
calculation date, and its end-date is after. This means the rent is
always the same in the years between START and END, but your formula
(Year = ...) don't consider it