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...
Maybe I am not the right one to suggest a solution to you.
But I am sure if you describe your plan on the file you have sent, you will come up with a proposed solution much faster.
Knowing the Excel version and the operating system would be an advantage
Thank you for your understanding and patience
Nikolino
I know that I don't know anything (Socrates)
Numbers will be added in the row however, not every cell will be filled with a number which will be a stripe. I need a formula that provides the sum of the last 5 added numbers. The numbers will not be continuous cell by cell in the row. I'm working with Excel 2010.