Input data into 1 cell to add to rolling average

[crichtth]

I'm trying to monitor a daily conversion rate. Is there a way to input daily conversion into 1 cell each day, and have that data add to a MTD rolling average? And then the next day I enter the new conversion into the same cell? Macros?

[#2]

@crichtth 

I wouldn't do it that way - you'd have no way to check if you entered an incorrect value.

Enter each day's value into a separate cell, so you have an overview of the data that have been entered.

Calculating the average is easy - use something like =AVERAGE(B1:B31). The AVERAGE function ignores blank cells.