Running Average in Numbers

Discussion in 'iWork Forum' started by daker, Aug 6, 2011.

  1. daker
    Offline

    daker iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Hello. I was wondering if anybody knew how to create a running average in Numbers. I take data weekly, and each time I need to add a new column of cells. These newly added cells need to be used as part of my average function, but I don't want to go back to the equation cell and add the newly created cells. Can someone make this easier for me? Thanks!
  2. 88raymond
    Offline

    88raymond iPad Fan

    Joined:
    Jul 22, 2011
    Messages:
    285
    Thanks Received:
    5
    Trophy Points:
    0
    Ratings:
    +5 / 0
    the best i can offer is to set up one-time.. increase to 52 columns initially for the 52 weeks of the year, and then use the average function to cover the entire range. you don't need to worry as the function considers only non-blank cells.
    Last edited: Aug 6, 2011

Share This Page

Search tags for this page
getting average on apple ipads numbers
,
how to average times in apple numbers
,

iworks numbers create an average

,

mac numbers moving average

,

running average in numbers