Dynamic summation of year totals [Anwsered] |
Dynamic summation of year totals
Hi,
I have a sheet with monthly revenue and cost data with column names like this:
Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13
Depending on the project start date, it could start from Feb-12 but it could also start from May-12, I generate those column names based on variable Launch_date that could take on different values.
I want to make a summary sheet to show quarter and annual revenues and costs.
The output should look like this if my launch date is Feb-12
Q1-12 (=sum of Feb-12 Mar-12), Q2 (=sum Apr-12 May-12 Jun-12) ; A12 (=sum Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 )
but it should look like this if my launch date is May-12
Q1-12 (=0), Q2 (=sum May-12 Jun-12); A12 (=sum May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 )
And in continuation it should also make sums for years 2013, 2014 and so forth.
Can anyone help?
Anwsers to the Problem Dynamic summation of year totals
Download Error Fixer for Free Now
How to Avoid Downloading Malware
Where are you getting the download?
There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.
Cancel or deny any automatic download
Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.
Avoid advertisements on download pages
To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.
Another Safe way to Repair the Problem: Dynamic summation of year totals:
How to Fix Dynamic summation of year totals with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your system. Run it, and it will scan your computer. The junk files will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.
Related: CD/DVD, NOT WORKING; CAN'T PAY OR INSTALL PROGRMAS, WIN 7,Changing Graphs In Excel,Clickfree C2N Backup Drive Works On Win 7 Laptop But Not Win 7 Desktop,Changing The Wallpaper In Windows 7 Starter,Check Box Enabled Equal A Certain Number Instead Of Formula In Cell,Computer Gets Blue Screen Every Day 'wl Merger.exe'.,Connect To Sqlsrv Through Php,Computer Does Not Recognize The DVD Drive.,Computer Won't Come Out Of Hiberntion,Computer Goes Into Power Saver Mode And Won't Come Out Of The Mode Without Rebooting The Computer.,Default Margin Settings In Word 2007,Delete Row If Date Is Over 2 Weeks Old From Today,Deleting The Portion Of The Integer.,Cursor Suddenly Vanishes In The Middle Of Typing On The Key Board Of My Lenovo Desktop With Windows 7,Date And Time Makes My Computer Freeze,Tips To Design Your Business Card,HEAL WITH HOMEOPATHY Homeopathy For Your Back,Joel Christopher,Skin Changes During Menopause,Rapid Techniques To Achieve Fat - 3 Rapid Rapid Techniques To Achieve Body Weight - Three Speedy Recommendations
Read More: How Can You Fix - Does the window 7 have the embedded duplicate copy/file finder software...?,Troubleshoot:DPFMate.exe problems,[Solved] Does anyone know why emails from a server were deleted after upgrading to Windows 7 (Window Live mail) from Windows Vista (Windows Mail)?,How to Fix - Disk Defrag won't open. Command prompt opens and closes in split second?,Tech Support: Download of Adobe Flash Player 11 failing,DA clients Remote Desktop with UAG DirectAccess HTTPS,Destroyed MBR and lost partitions in windows 7 ( + deleted profile files),Data Execution Prevention problem,Does Word 2010 have a repeating content control like Word 2013?,Downloaded game file corruption