View Single Post
  #1   Report Post  
sentebale sentebale is offline
Junior Member
 
Posts: 1
Default Sumproduct fails after turn of the year

I hope someone could help me to solve this issue please.

This sumproduct formula should pull data from the first possible date (for example 1st september) to the current day, whatever that may be.

This works perfectly until the turn of the year, from 1 January it returns zero instead of the accumulated total.

=SUMPRODUCT(($D$5:$D$286)*($C$5:$C$286<=DATE(2000+ MID($B2,FIND("/",$B2)-2,2),MONTH(TODAY()),DAY(TODAY())))*($G$5:$G$286=$D $2))

Cell B2 holds the year value 2014/15

The workbook is closed

many thanks