I am trying to create spreadsheet that allows for a year to date calculation for sales of items by week and allow me to pick a week and show what sales number there has been in that week. Having not used excel daily for four years, I am a little rusty! I have a previous spreadsheet I am trying to copy from, but the formulas are far to complicated to copy.
In row 5 from column L I have the week number to all 52 weeks.
Row A, list all the items.
I am looking to return in row J. At the top of this row, I can change the search week and it will show that weeks performance.
When I put it in week 4, for example, I want a formula that adds all numbers for that item up to week 4. Likewise if I change the performance week to week 11, I need it to add all weeks up to that week. It will also need show week 52.
Is there a formula out there for this?
Bookmarks