Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running total formula
My cells look like this.
in a:4 value is 6. In b:4 the value is 112. in a:5 value is 7. In b:5 the value is 125. in a:6 value is 6. in b:6 the value is 110. in a:7 value is 7. in b:7 the value is 126. What I want to do is have the differences in the c:4 thru c:7. would be b:7-b:5 . 1 would be the result in c:5. then the result of b:6-b:4. the result would be minus 2. I am working with the numbers 4,5,6and 7 in the a: cell range. that range is constant. the b range values change. To keep the totals runing I want to use the c:range for the 4's, d:range for the 5's, e:range for the 6's and f:range for the 7's. What formula do I need to put in the c,d,e,and f ranges to do this. Thank you. always dazed and confused Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running total by date (not sorted by date though...) | Excel Worksheet Functions | |||
Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
Need a formula to add the total # each time it finds a name | Excel Discussion (Misc queries) | |||
% of running total in pivot table | Excel Discussion (Misc queries) | |||
XL formula - total of row = total of column | Excel Worksheet Functions |