Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » Sum last 10 values

Sum last 10 values

Previous | Next
Latest post Mon, Dec 21 2009 6:49 PM by Derek McGill. 2 replies.

  • Mon, Dec 21 2009 4:19 PM

    Sum last 10 values

    Reply |Contact

     

    Hi all

    With the data below :-

    how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25)

    Data is added to columns 12 to ? at a later time.

    Derek

     

    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
    1 1 5 0 1 4 1 7 2 4 7
    3 5 2 2 2 2 3 2 3 2 2

     
    Filed under: , ,
    • Post Points: 21

  • Mon, Dec 21 2009 5:34 PM In reply to

    Re: Sum last 10 values

    Reply |Contact |Mark as Not Answer

    Try

     

    =SUM(2:2)-IF(COUNT(2:2)>10,SUM(A2:INDEX(2:2,COUNT(2:2)-10)),0)

    Regards

    Bob

    • Post Points: 21

  • Mon, Dec 21 2009 6:49 PM In reply to

    Re: Sum last 10 values

    Reply |Contact |Mark as Answer

    Thanks Bob that works a treat.
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.