| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
Can you give an example result on that data?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Dee/Daes" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
Bob, sorry my columns went crazy! So I have attached a file Thanks for any help Dee +-------------------------------------------------------------------+ |Filename: Excel test.doc | |Download: http://www.excelforum.com/attachment.php?postid=4724 | +-------------------------------------------------------------------+ -- 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
It wasn 't the data that was the problem, but understanding what result you
want to get. What is the answer that you want a formula to arrive at? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Dee/Daes" wrote in message ... Bob, sorry my columns went crazy! So I have attached a file Thanks for any help Dee +-------------------------------------------------------------------+ |Filename: Excel test.doc | |Download: http://www.excelforum.com/attachment.php?postid=4724 | +-------------------------------------------------------------------+ -- 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
Hope the following makes sense, look at attachment. I need a formula to give me the answers under "amount" column. Thanks, Dee I need a formula that takes April 1 meter reading from April 5 and then averages that number for 4 days and same thing for April 5 from April 7. -- 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
No attachment.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "Dee/Daes" wrote in message ... Hope the following makes sense, look at attachment. I need a formula to give me the answers under "amount" column. Thanks, Dee I need a formula that takes April 1 meter reading from April 5 and then averages that number for 4 days and same thing for April 5 from April 7. -- 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
averaging & ???
file attached Derrell +-------------------------------------------------------------------+ |Filename: Excel test.doc | |Download: http://www.excelforum.com/attachment.php?postid=4731 | +-------------------------------------------------------------------+ -- 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 |
| Reply |
| 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 | |||
Linear Mode
