If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...
The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...