Another quick Excel question

Discussion in 'macOS' started by yg17, Apr 1, 2007.

  1. yg17 macrumors G5

    yg17

    Joined:
    Aug 1, 2004
    Location:
    St. Louis, MO
    #1
    I have a cell that calculates an average from all the cells in column J, starting with J2.

    For the formula right now, I have:
    =AVERAGE(J2:J31)

    But, I want to be able to keep adding stuff beyond J31 and not have to keep modifying the formula. I thought maybe a wildcard like:
    =AVERAGE(J2:J*)
    would work, but it didn't. Is there some way to do this? Thanks
     
  2. WildCowboy Administrator/Editor

    WildCowboy

    Staff Member

    Joined:
    Jan 20, 2005
    #2
    There might be a more elegant way of doing it, but I usually just make the range much larger than I'm know I'm going to need (something like J2:J131).
     
  3. yg17 thread starter macrumors G5

    yg17

    Joined:
    Aug 1, 2004
    Location:
    St. Louis, MO
  4. bearbo macrumors 68000

    bearbo

    Joined:
    Jul 20, 2006
    #4
    this is not elegant per se, but if you don't know how many numbers you'll have, this may work better

    =(SUM(C:C)-C1)/(COUNT(C:C)-COUNT(C1))
     

Share This Page