+ Reply to Thread
Results 1 to 3 of 3

Calculate average weeks open

  1. #1
    Forum Contributor
    Join Date
    02-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    191

    Calculate average weeks open

    Hey Everyone,

    I'm trying to put together a formula that calculates the average number of weeks a store has been up. I manually calculated it in row 7, but I would want to do this with 100's of stores, so I want it to be automated. Any ideas?

    Much appreciative for the help!

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,676

    Re: Calculate average weeks open

    see attached file.
    I have added formulas in the highlighted area.
    I am assuming that you will add values in row 4.
    You can extend the formulas horizontally and vertically as far as you like.
    I added values in columns P and Q just to test the formulas.
    Let me know if this works for you.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Calculate average weeks open

    This is an interesting one with aggregate average, try:

    C7=SUMPRODUCT($C$4:C4*LARGE(COLUMN($C$4:C4)-COLUMN($C$4)+1,COLUMN($C$4:C4)-COLUMN($C$4)+1))/C5

    and copy across row 7..
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

+ 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. Help finding last weeks average?
    By pjhdude in forum Excel General
    Replies: 13
    Last Post: 01-26-2017, 12:13 PM
  2. 12 weeks rolling average
    By Sri.n in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 05:25 AM
  3. [SOLVED] Average hours across several weeks
    By jaycee66 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2012, 03:24 PM
  4. Replies: 2
    Last Post: 09-16-2012, 01:58 PM
  5. [SOLVED] I have 12 scores over 12 weeks . I want to average the highest 5
    By Directioneng in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. [SOLVED] I have 12 scores over 12 weeks . I want to average the highest 5
    By Directioneng in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  7. I have 12 scores over 12 weeks . I want to average the highest 5
    By Directioneng in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 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