OK, here's a quick easy question. I'm recording the number of times an event occurs in column D. In column E, I'm recording the total of times this event has occurred so far. In column F, I want the average at the end of the day. By this I mean, if by day 3 the even has occurred a total of 9 times at 3 times a day, I want F4 to equal 3. If on day 4 it happens 4 times, I want F5 to equal 3.25 and F4 to remain at 3 for reference. Am I making any sense?
Thanks!
Bookmarks