How to Remove Popups?: Troubleshooter of Error: Add data tillmlast year

Add data tillmlast year

Hi,
I have data for 2 years, when I enter a date of the current year it is showing data till date, similarly in another cell I want it to show me the cumulative sum till the same day less one year.
ex: If I ask for data till 12-Nov 2013 for the current year it should show me cumulative sum till 12-Nov-2012

Please help

Anwsers to the Problem Add data tillmlast year

Download Error Fixer (Free)

=SUMPRODUCT($B$1:$R$1=text12!B4)*(($A$2:$A$500)<=DATEVALUE(text12!$T$5))*(YEAR($A$2:$A$500)=YEAR(text12!$T$5))*$B$2:$R$500)

In the above formula, where I think you have missed out a left parenthesis right after SUMPRODUCT, data is summed from January 1st of the year of the date in text12!$T$5 until the date itself.

With the following modified formula, the sum goes from January 1st of the year just BEFORE the year of the date in text12!$T$5 until the date which is exactly one year BEFORE the date in text12!$T$5.

=SUMPRODUCT(($B$1:$R$1=text12!B4)*(($A$2:$A$50)<=DATE(YEAR(text12!$T$5)-1,MONTH(text12!$T$5),DAY(text12!$T$5)))*(YEAR($A$2:$A$50)=YEAR(text12!$T$5)-1)*$B$2:$R$50)

The changes from the previous formula are highlighted.

Hope this helps / Lars-Åke

Download the Microsoft Windows ISO (installation device) from the following website:
http://www.microsoft.com/en-us/software-download/windows10
Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
Extract the ISO file to a separate USB device or burn the program to a compact disc.
Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Another Safe way to Fix the Problem: Add data tillmlast year:

How to Fix Add data tillmlast year with SmartPCFixer?

1. Download Error Fixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.