Calculate the most recently entered data in columns?
Good morning all,
new to the forums. Thanks in advance for any help/ideas.
As an example, I enter sales for some 400 items on a daily basis. In order to maintain a chronological record of sales, I simply add a column with a header of today's date, and enter the sales for that day.
In a specified cell,(demonstrated in cell C8 of the attached worksheet), I would like to automatically calculate the average of the last three days of sales entered for the specified item (Demonstrated in cell A8). I'd also like to replicate a similar process for a seven day period, and thirty day period.
I'm open to all thoughts and suggestions!
Again, thanks in advance.
-Mike
|