# getting averages weekly, two wks back, three weeks back on data populated daily by selecti

1. ## getting averages weekly, two wks back, three weeks back on data populated daily by selecti

Good day good people

Can someone help me here. I want to have weekly averages, two weeks back and three weeks back to be calculated and updated at the top column for every data/ product entry based on the date that I can select from a drop down list or just input the date.

Please find attached the sheet below.

thank you

2. ## Re: getting averages weekly, two wks back, three weeks back on data populated daily by sel

In I10 Cell

=WEEKNUM(A10,2)

Drag it down...

In B6 Cell

=IFERROR(AVERAGEIF(\$I\$10:\$I\$1048576,WEEKNUM(\$B\$2,2)-(ROWS(1:\$4)-1),B\$10:B\$1048576),0)

Drag it down and right...

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1