I’m trying to keep a running total (headcount) in my example:
As you can see, the result for every row, except the first, seems to be some sort of cell identifier (as text) with the
movement value added (again as text).
I’ve seen adding-values-from-previous-rows but the formula format using square brackets doesn’t seem to work.
Is it possible to write a formula that takes a value from the previous row?
Additionally, it seems that when using
nth you only get back the ‘display value’, which in my example is OK, but it would be really nice if there was a way to refer to a specific column.