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

This sumproduct formula should pull data from the first possible date (ie 1st september) to the current day, whatever that may be. It isn't. It just pulls in the cumulative total
for the entire year.
So if today is 2 October, then the sumproduct would be from 1st september to 2nd October but in the year range 2014/15 as held in B42


=SUMPRODUCT(('[Sales 2015.xlsm] Orders'!$E$13:$E$300)*('[Sales 2015.xlsm] Orders'!$D$13:$D$300<=DATEVALUE(TEXT(TODAY(),"dd-mm-")&RIGHT($B42,2))*('[Sales 2015.xlsm] Orders'!$H$13:$H$300='[Sales 2015.xlsm] Orders'!$D$7)))


Cell B42 holds the year value 2014/15

The workbook Sales 2015 is closed

many thanks