redonthehd
New Member
- Joined
- Sep 17, 2014
- Messages
- 3
Hi Everyone, I am new to the Group. I have an interesting formula problem. We have a spreadsheet and log for our 6 or 7 products we sell. there are 15 to 30 sales a day so each line is a sale. Column A is the date of the sale in format 9/8/2014, column B is the name of the customer, C the phone number, and D through L are product columns so Like D is Azteca and so on.
Now on separate tabs I have the running totals and graphs for each particular product. showing monthly sales but I want to have a running 7 day average of units sold for each product. I do this manually now with this formula <bdo dir="ltr">=SUM(MAIN!D771:D1153)/7
Each day I manually change the first cell number to reflect the date 6 days prior to the current date we are inputting.
I have searched and looked and unable to find a way to automate my manual changing of the current sales date minus 6days and put that in the formula to give me a 7 day running average. Any Ideas or Thoughts?
</bdo>
Now on separate tabs I have the running totals and graphs for each particular product. showing monthly sales but I want to have a running 7 day average of units sold for each product. I do this manually now with this formula <bdo dir="ltr">=SUM(MAIN!D771:D1153)/7
Each day I manually change the first cell number to reflect the date 6 days prior to the current date we are inputting.
I have searched and looked and unable to find a way to automate my manual changing of the current sales date minus 6days and put that in the formula to give me a 7 day running average. Any Ideas or Thoughts?
</bdo>