I have a column with monthly volumes, but occasionally there will be a
day or two were no volume is entered. I need to find the average of
the last 4 volumes entered. Please see attachment.


The volume for June-05 should be the average of 1692.6, 1532.9, 1761.5
and 1787.9. Is there a formula that will find the most recent 4
volumes and average them.

Thanks for any help you can give.


+-------------------------------------------------------------------+
|Filename: Question.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=3547 |
+-------------------------------------------------------------------+

--
Ninjafer
------------------------------------------------------------------------
Ninjafer's Profile: http://www.excelforum.com/member.php...o&userid=24711
View this thread: http://www.excelforum.com/showthread...hreadid=382770