Forum Discussion
HrtJOr
Feb 02, 2021Copper Contributor
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...
HrtJOr
Feb 02, 2021Copper Contributor
Well, it must be something like this but still isn't working. I have the formula in a column but this one needs to be in a row. But can't find it out.
HansVogelaar
Feb 02, 2021MVP
It works in the workbook that I attached...