# rolling total

1. ### Help with sliding commission with rolling annual 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...
2. ### Rolling Total Calculation v. Pivot Table

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...
3. ### Rolling Total for 2 adjacent columns

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...
4. ### Rolling total

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...
5. ### Rolling 12 Month Totals from Different Worksheets

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...
6. ### Auto Rolling YTD number vs. previous YTD number& Current Month to Date vs. Previous Year MTD

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...
7. ### finding 60 minute peaks

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...
8. ### Period and Yearly rcumulative totals

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back