Sumproduct formula over cumulative date range failing

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

Thanks for your reply, I'll try your formula change and report back. Sept 1st start date isn't hard and fast, just an example.

xlnitwit, thanks for the formula revision. It gives me the same result as my original formula so not the accumulated total to date.

As requested see sample workbook, hope that helps.
Regards

Unfortunately moving the system date forward to 1st January the formula fails and reports zero.

Up to 31st December it's fine, it just fails at the turn of the year. Do you have a solution please ?

for example in the sample sheet if I add dates and data going forward into 2016 and move the system date forward to a date past 31st December, instead of continuing to count the accumulated sales number it reverts to zero.

The sales year would run from 1st Sept 2015 to 31st august 2016, so the formula needs to count the accumulated sales to todays date whatever that may be.
I want to be able to see the sales position across a number of years at the current date.
Does that make anymore sense ?

Updated sample file.

move your system date past31st December to see what I mean.

Hi daddylonglegs, thanks for the reply and alternative.

I'd really like to get this formula working so that it will span 2015/16 properly, any ideas xlnitwit ?

=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))

Many thanks