The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Weekly Average

    Discussion in 'Windows OS and Software' started by surfasb, Nov 27, 2007.

  1. surfasb

    surfasb Titles Shmm-itles

    Reputations:
    2,637
    Messages:
    6,370
    Likes Received:
    0
    Trophy Points:
    205
    I have a series of data like so.

    Column A is Dates

    Column B is "Number of Calls"

    Column C is "Number of Sales"

    I'm trying to do weekly averages on a seperate sheet

    I was trying to figure out how get Excel to add 7 to the cell reference so that the pattern is like so:

    =average(B2:B8)
    =average(B9:B15)
    =average(B16:B22)


    Any help would be appreciated
     
    surfasb, Nov 27, 2007
    #1
  2. Jeff

    Jeff Notebook Retard

    Reputations:
    3,106
    Messages:
    2,501
    Likes Received:
    0
    Trophy Points:
    55
    so let me get this straight, you want to work out a way to replace the B8/B15/B22 with a general expression that you can copy and paste into the average formula? how hard is it to add 6? you are goign to have to type each one individually anyway, so simply adding 6 to the value, and then typing it in would be quicker.

    in other words, i'm not sure how to :D :D :D
     
    Jeff, Nov 27, 2007
    #2
  3. surfasb

    surfasb Titles Shmm-itles

    Reputations:
    2,637
    Messages:
    6,370
    Likes Received:
    0
    Trophy Points:
    205
    Yeah, I have like 100 weeks to go through, so right now, i'm just typing away here hoping I don't make a mistake..... I make a mistake in one, it will throw off every one after that.....

    I was trying to get the Autofill to do it for me.
     
    surfasb, Nov 27, 2007
    #3