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!
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks