Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW TO CALCULATE RUNNING TOTAL
i WORK WHERE WE DO CAR RENTALS AND THE PROBLEM IS THAT i WANT THE KILOMETERES
TO BE COUNTED. i HAVE THE KM WHEN THE CLIENT LEAVED ( A ) WHEN HE COMES BACK ( B) BUT i CAN FIGURE OUT HOW TO GET (C) TO AUTOMATICALLY CALCULATE THE KM DRIVEN. I HAVE TRIED TO READ THE FORUMS BUT MAYBE MY LITTLE MIND CANÈT GRASP IT. ANY HELP? THANKS IN ADVANCE.... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW TO CALCULATE RUNNING TOTAL
Let's say the Km-start value is in cell C1 and the Km-return value is in
Cell D1. The in cell E1 type =D1-C1 to get the difference If you have columns of data you can copy this formula down the column by dragging the fill-handle (the solid black square in the lower right corner of the selected cell) I do urge you to get a book like Excel for Dummies so you can find out all the time saving things Excel can do for you best wishes best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "MTLCOOCOO" wrote in message ... i WORK WHERE WE DO CAR RENTALS AND THE PROBLEM IS THAT i WANT THE KILOMETERES TO BE COUNTED. i HAVE THE KM WHEN THE CLIENT LEAVED ( A ) WHEN HE COMES BACK ( B) BUT i CAN FIGURE OUT HOW TO GET (C) TO AUTOMATICALLY CALCULATE THE KM DRIVEN. I HAVE TRIED TO READ THE FORUMS BUT MAYBE MY LITTLE MIND CANÈT GRASP IT. ANY HELP? THANKS IN ADVANCE.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
How can I use a formula to calculate a running sub-total in excel | Excel Worksheet Functions | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions |