ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sumproduct fails after turn of the year (https://www.excelbanter.com/excel-discussion-misc-queries/453861-sumproduct-fails-after-turn-year.html)

sentebale

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


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com