Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averaging & ???
We need a formula to do the following: Subtract a given reading from the one previous to it and divide it by the number of days in between. That average number then goes in a column. The other BIG problem is that meter readings are never on the same day month to month. Example: Date Meter Volume 1 18,179,000 2 3,000 3 3,000 4 3,000 5 18,191,000 3,000 6 2,500 7 18,196,000 2,500 I truly appreciate any help that you can provide....Im turning blue trying to figure out myself. Dee -- Dee/Daes ------------------------------------------------------------------------ Dee/Daes's Profile: http://www.excelforum.com/member.php...o&userid=33917 View this thread: http://www.excelforum.com/showthread...hreadid=537185 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging using relative references across sheets | Excel Discussion (Misc queries) | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) | |||
2 part question on averaging | Excel Discussion (Misc queries) | |||
selective averaging | Excel Worksheet Functions |