Forum Discussion
Last 5 added in a row
I am looking for a formula which can sum the last 5 added values in a row. My formula is missing one thing but I can't solve it. I know it's an array formula and needs to be closed with Ctrl shi...
Try this formula: =SUM(OFFSET(C7,0,COUNT(D7:AW7),1,-5))
And giving credit where it's due, I found the source for this formula at this website--which I commend to you.
https://exceljet.net/formula/average-last-5-values
I had to modify it from a formula that calculated the average of the last five rows in a column, and that modification is the one above.
I'll let you read the explanation at the exceljet site. And I also recommend bookmarking that site as a valuable one for self-education.