Results 1 to 4 of 4

Thread: formula to compute average of last three numbers while ignoring formulas

  1. #1
    Seeker Kihoro's Avatar
    Join Date
    Sep 2012
    Location
    Nairobi, Kenya, Kenya
    Posts
    6
    Articles
    0

    formula to compute average of last three numbers while ignoring formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi guys,
    please find attached worksheet - test1
    Am trying to have the formula in c31 sum and calculate the
    Average of any last three numbers in range f25:bi25.
    I have a formula in cells range AL25:BI25 (=IF(AL4>0,(AL4-AK4)/AK4,"")
    That will calculate the percentage as long cell AL4 is greater than zero.
    The formula in CI is supposed to calculate the average of the last three numbers while ignoring
    The formula in the cell AL25:BI25. The formula returns a #VALUE error
    How do I go round this problem?
    I want the formula in CI to ignore the formula in cell range AL25:BI25 and just compute the average of the last three numbers only..

    thanks alot in advance
    Attached Files Attached Files

  2. #2
    Nevermind .....
    Last edited by tommyt61; 2012-09-19 at 03:42 PM.

  3. #3
    See if this will work for you.

    =AVERAGE(INDEX(f25:bi25,MATCH(9.99999999999999E+307,f25:bI25)-3+1):bi25)

  4. #4
    Seeker Kihoro's Avatar
    Join Date
    Sep 2012
    Location
    Nairobi, Kenya, Kenya
    Posts
    6
    Articles
    0
    thanks alot Tommyt61,
    it worked.!
    much appreciated.
    have a good day.

Posting Permissions

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