rolling total

Excel 2007 Windows 8.1 Hello everyone, and thank you in advance!!! I am creating a commission worksheet for my real estate agents so they can easily track their earnings for every deal. I have essentially found the solution (thanks to the second-half of a YouTube post from MrExcel), but do...

Excel 2007: <tbody> A B C D E F G H I J K L M N 1 Color % Red % Blue 1/1/13 2/1/13 3/1/13 4/1/13 5/1/13 6/1/13 7/1/13 6 Month Rolling Total 6 Month % Red 6 Month % Blue 2 Orange .5 3 6 2 5 4 2 6 =L2*B2 =L2*C2 3 Purple .5 .5 7 2 3 12 4 15 6 =L3*B3 =L3*C3 4 Green .5 4 4 14 10 1 8...

This is my first post so please be patient with me! I use Excel 2007. I have a data set that tracks ingredients in chemical products. For example sake the chemical product is a mixed color, and the calculated ingredient is a primary color. I need to calculate the quantity of two primary colors...

What I am trying to do is keep track of billed and unbilled revenue from month to month by employee & contract. I have created a workbook with 12 worksheets (Jan-2013 through Dec-2013). In the January workbook, I am hard coding the December 2012 ending balances, but I can't figure out what...

Looking for a way to create a 12-month rolling total in which the totals are not only in the current worksheet but from other worksheets. The worksheets are setup identical and the tab names have a name and year (i.e., AS0904-2012). Each worksheet represents a calendar year. The totals are in...

I need to create a comparison of MTD, YTD, and a 3 month Comparison in Excel 2007 using the current date (mm). I do not want to have to change a number to signify the month. The Data is laid out like this: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

Hi all, this is my first post and i am still a novice to excels wonderful capabilities.. so please bear with me and keep in mind that i am trying to learn it :smile: i have a massive list (a lot of colums and rows over 90000 )- with a colum for a timestamp and a colum with values for this...

I have data that is grouped by weeks of a period. PD5Wk4 refers to period 5 week 4. It is relative easy to show data on a dashboard for a 1 week period (WTD or Week-to-date). However, I am not sure how to write the formula that will show cumulative data. For instance, I need to show...