+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    Gabz, Botswana
    MS-Off Ver
    2013
    Posts
    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
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    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...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count back 4 weeks, skipping blank cells
    By Lars53 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2014, 06:28 PM
  2. [SOLVED] Bring back date from last populated cell in range
    By tiger01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2013, 06:26 AM
  3. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  4. Formula For Daily, Weekly And Monthly Averages
    By jrusso in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2012, 08:10 PM
  5. [SOLVED] Read todays date, then go back 17 weeks
    By galvinpaddy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2012, 10:22 AM

Bookmarks

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