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

Attached Files

Sales.xlsx (9.2 KB, 11 views)