averaging & ???

[Dee/Daes]

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

 

[Bob Phillips]

Can you give an example result on that data?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Dee/Daes]

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 |
+-------------------------------------------------------------------+

 

[Bob Phillips]

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]

Hope the following makes sense, look at attachment. I need a formula t
give me the answers under "amount" column.
Thanks, Dee
I need a formula that takes April 1 meter reading from April 5 and the
averages that number for 4 days and same thing for April 5 from April 7

 

[Bob Phillips]

No attachment.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Dee/Daes]

file attached
Derrell


+-------------------------------------------------------------------+
|Filename: Excel test.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4731 |
+-------------------------------------------------------------------+