This is the data that I am using (for example). The reason I want the
average is find out the % of times that the item is closed (that is why
I am using 1 and 0's) . But since I fill in the data everyday, I want
know the running average as I am entering the values. Rather then
having a column for calculating the current average next to every date.

I tried your formula and it was not exactly what I was looking for
(besides it didn't work)

I hope this helps better understand the problem.


[A] [b]
Date Closed
July 31, 2005 0
August 1, 2005 1
August 2, 2005 0
August 3, 2005 0
August 4, 2005 1
August 5, 2005 1
August 6, 2005 0
August 7, 2005 0
August 8, 2005 1
August 9, 2005 1
August 10, 2005 1
August 11, 2005 1
August 12, 2005 0
August 13, 2005 1
August 14, 2005 0
August 15, 2005 0
August 16, 2005 1
August 17, 2005 1
August 18, 2005
August 19, 2005
August 20, 2005
August 21, 2005
August 22, 2005
August 23, 2005
August 24, 2005
August 25, 2005
August 26, 2005
August 27, 2005
August 28, 2005
August 29, 2005
August 30, 2005
August 31, 2005
September 1, 2005
September 2, 2005
September 3, 2005