Let me show you what I want to achieve:

I start with a range of figures and I want to see how the range is built horizontally, one figure at a time.

I am able to get the last line of the result by using a REDUCE function. Until here, everything is fine.

However, if I want to see how the REDUCE function has built its result, line by line, and I try it by replacing REDUCE with SCAN, I simply get a #CALC! error. I simply do not understand it.

In my way of understanding these two functions, if one works, so should it the other.

Any suggestions?