# Calculate average weeks open

1. ## 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!

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

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

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