Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Excel formula

  1. #11
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again Dave,
    I put numbers in column B1:B32, with blank cells at B12,B18,B19, then put the formula into C10 and copied down to B32. (see numbers below) The formula looks as though it is working, in that the same average is repeated where there are blank cells; the problem is the averages are not correct.
    Thanks again, Barney

    20
    23
    18
    21
    24
    22
    23
    23
    27
    29 29.00
    27 28.00
    28.00
    21 25.67
    25 25.50
    19 24.20
    29 25.00
    26 25.14
    25.14
    25.14
    21 24.63
    24 24.56
    14 23.50
    26 23.73
    27 24.00
    22 23.85

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,425
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    What formula did you use and did you correct the cell references ?

    The formula was written with data starting in Row 10.

    You can :
    a) put the formula in your first row, edit the cell references and copy it down.

    or
    b) if you do NOT want to edit the formula, copy your test data and paste it starting at B10.

    You can use the area at the top for other statistics.

    The formula gives correct answers on my test data and on the data you presented.




    [ This Message was edited by: Dave Patton on 2002-04-03 12:57 ]

  3. #13
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave,
    You were right I did something to the formula that made it average incorrectly. In any case I now have it in my spreadsheet where I keep a modified handicap for 14 golfers. It works beautifully, precisely the way I wanted it to work.
    I can't say "thank you" enough for being so generous with your time and expertise. You have been very very helpful and very patient with this Excel novice and I am most appreciative.
    Barney

  4. #14
    Board Regular
    Join Date
    Apr 2002
    Location
    St. Louis
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here is a solution to your dilemma. Not the most elegant, but it works.

    First, set up a worksheet with two tables: Table 1 will contain the data entry (scores); Table 2 will contain a rolling average calculation.

    Set up a second worksheet that contains lookup formulas that refer to the scores in Table 1. Display as many as you choose. Then setup a column to display the rolling average. The cells in this column will refer to the Table 2 in the other worksheet.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •