averaging & ???

  • Thread starter Thread starter Dee/Daes
  • Start date Start date
D

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
 
Can you give an example result on that data?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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)
 
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
 
No attachment.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Average Calc for duplicated values only 0
SUMIF with Multiple Conditions 5
Sum up values from adjacent column 4
Dropdown Box to Select Data from Another Sheet 2
Calculate running target by days in the month 2
Any suggestions 2
Help Help Help Help!!! 2
'Automatic' sorting to printable report 1

Back
Top