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