Remember Me?

#1
October 4th 17, 11:36 AM
 Junior Member First recorded activity by ExcelBanter: Oct 2017 Posts: 1
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jack Deuce Excel Worksheet Functions 2 January 6th 13 02:02 PM sam Excel Discussion (Misc queries) 1 February 24th 10 02:41 AM MDI Anne Excel Discussion (Misc queries) 5 June 20th 08 07:53 PM Benjamin Excel Discussion (Misc queries) 1 September 20th 06 04:29 PM Bumblebee Excel Worksheet Functions 8 August 19th 06 06:59 PM

All times are GMT +1. The time now is 08:24 PM.