running total

  1. A

    Max Drawdown, portfolio

    Greetings all - I think I am close to having this right, but certainly am missing something. I am trying to calculate Max Drawdown of a portfolio, and have the following: CS2 =(running total equity curve) CT2 =max(CS2,CT1) CU2 =IFERROR(IF(CS2=CT2,0,MAX(CU1,CT2-CS2)),"") CV2...
  2. M

    Added columns to pivot table stop running totals

    I would like to re-post my original post with a better example for the issues I am having. When I use the running total with these columns shown, the running total works. <colgroup><col><col span="2"><col><col></colgroup><tbody> Item name Item No. Date of Movement Sum of Quantity Running Total...
  3. R

    Apply working single row formula to all further rows with Click Button

    Hi guys, Complete newbie to VBA! I have created a stock management worksheet that I "simply" want to add or subtract from a running total with a click button to carry out the function. At the minute I have the following code: Private Sub commandbutton1_click() Range("J5").Value =...
  4. B

    Subtract cell value from running total based on if another cell is filled

    Hi There- I have a spreadsheet that has a running total in cell G5. I would like to subtract a cells value from range B4 to B21 if the corresponding cell in range D4 to D21 is filled with PAID. Meaning, if cell D8 = "PAID" then subtract cell B8 from running total in cell G5. Can someone help...
  5. R

    YTD Sum of Plan values to be compared to Actual values

    I am currently working on a controlling dashboard for SharePoint, but have to figure out the formulas in Excel first. I want to compare a YTD planned value (B4) with a YTD actual value (C4) and of that number insert a traffic light showing the YTD status vs. the plan. Below you see the logic...
  6. C

    HARD: PivotTable - Hide same values in running total? (with pictures)

    Hi. Who is expert enough to solve this? In a PivotTable, I would like to hide successive equal values in a running total. That is, I would like same successive values to be blank. This is what I have: https://ibb.co/es8Hqv This is what I want: (I just made the font white) https://ibb.co/gRgFca
  7. A

    Getting running total and balance

    Hi Im new to here, I have following question <tbody> Date Product Production Cumulative Dispatch Balance 1 Jan 17 Apple 10 10 0 10 2 Jan 17 Banana 12 12 0 12 3 Jan 17 Apple 15 25 14 11 4 Jan 17 Apple 16 27 14 13 </tbody> ****** id="cke_pastebin" style="position: absolute; top: 41px...
  8. N

    Restart running total after X number of rows

    I'm trying to come up with a formula that can 'restart' a running total after 12 rows. Currently my data looks like this where the running total is calculated using the formula in C2 is =SUM($B$2:B2) This works fine until I reach row 14. Here I would like the formula to 'restart' so it...
  9. E

    Cumulative sum that restarts count on condition

    Hi all, Below is a copy of the data. I need to have a cumulative sum of column b, that resets the count to zero if i encounter a reset condition. The problem is I do not know when the reset(s) will occur( It is not a fixed location), so the challenge is catching the moving target. Also the...
  10. K

    Running total with lag between commencement and completion

    Using Excel 2007 on Windows XP. Assume the following worksheet layout: <tbody> 1 Commencements 1 1 3 1 4 3 4 2 1 2 3 2 Period between commencement and completion 4 4 4 3 3 3 2 2 2 2 2 3 4 Completions 5 4 period assumption 1 1 3 6 3 period assumption...
  11. M

    MTD and YTD in a running total

    As stated in a previous thread I am creating a KPI dashboard for my company. In this dashboard there are 24 data sheets that connect to the dashboard that can be viewed by the week of MTD or YTD. One of the data sheets is for a client count which is a running total. Which obviously doesn't work...
  12. S

    VBA or Formula for Running Total

    Hey Everyone . . . Looking for some assistance on a formula or VBA. I have the below dataset and I am trying to automate the calculation of the running total. Basically, I need it to say, if the user stays the same, the processID stays the same, the client id is new, and the closed column is...
  13. P

    Adding value in single Cell

    Hi, pls help me .. i have value in C2 which is change daily . i want to do C2 value Total at D2 as Running total like yesterday c2 value is 10 and d2 value also 10 today c2 value is 5 then d2 value will be 10+5=15 pls suggest me a formula or vb code.
  14. P

    Keep Runing Total

    Hi Guys, I have a value in B2 and and i want to do total of this value on C2 and D2 Format like this DAY WEEK MONTH IF I FILL 50 IN DAY CELL THEN WEEK WILL BE 50 MONTH ALSO WILL BE 50 After that i change value in day 10 than Week value auto calculate 50+10=60 and month value also 60...
  15. 9tanstaafl9

    Eliminate duplicate entries but keep running total?

    Basically I have a simple set of data sorted by cost code (col B). Each cost code has an amount (col C). There may be one or more of each cost code. When all is said and done, what I want is to see only one of each cost code. If more than one had originally existed, I want the total to be...
  16. C

    Need running total formula based on adjacent column text color

    I need to create a running total based on the color of the text in an adjacent column. I am using 2007 Excel. Essentially, every time I enter a date in "black" text, I need the count to go up by "one"; every time I enter a date in "red" text, I need the count to go down by "one". I need the...
  17. S

    YTD Pivot Table

    Hi All, Sorry if this has been asked before, but I've had a search and can't find an answer. I'm using Excel 2010 and Windows 7 I'm trying to find a YTD total in a pivot table. I've been able to use the running total function to get a YTD figure from my data. However, this table currently...
  18. I

    Annual Running Totals - First Period Values

    Hi I have this problem: I am extracting data from Cognos Controller. Cognos Controller stores data in accumulated numbers over the year. To find the period value (as opposed to the accumulated value) for a period I have first made a calculated column in my Fact-table that makes a transactions...
  19. P

    Pivot Chart \ Pivot Table show a cumulative Overall percentage for multiple months.

    I have a working Pivot Chart based upon a Pivot Table. Sorry I could not get an image of my chart to load. Background - there are multiple items each month which were either completed "ON Time" or Late. "ON Time" and Late are stacked bars and the % On Time is a line using the secondary Y...
  20. D

    Decreasing running total grouped by dates in Pivot. Excel 2007

    Hi, This is my first post here, I hope someone can help me with this as I have been unable to get a solution using running totals, calculated fields and differences from in the pivot table. I am quite sure the solution is not so difficult so hopefully someone can give me a hand on how to do it...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top