Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    8

    Finding average of last 10

    Hi,
    I need help.

    I am working in excel and trying to write a formula that will calculate the average of the last ten numbers. I want to refresh my data and the formula with always find the last ten.

    I have three columns:

    column 1 - date
    column 2 - mill
    column 3 - levels

    I have 703 rows. I wanna focus on column 3

    Thanks

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Don't have Excel handy, but I think this should work:

    Code:
    =AVERAGE(INDIRECT("C" & ROWS() - 9 & ":C" & ROWS()))

  3. #3
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    For reference, this is a duplicate thread of the one in the Excel board:
    http://www.dbforums.com/microsoft-ex...last-10-a.html

Posting Permissions

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