You can assign a name to any summary formula cell. This can be done by adding cell name after right bracket
]
For example cell value in XLS template like
$[SUM(A1:A20)]sum
assigns name
sum
to the address of this cell. Such cell can be referenced later in some other formula cell by putting its name between
@
symbols. For example
$[B1 + @sum@]sum2
As you see this cell also may be referenced in some other formula using
sum2
name.
You may need to reference row formula cells in some summary formula. The name of row formula cell will be translated to corresponding cell range if formula will be referenced later with its name in
@
symbols.
Let's look again at department example template screenshot
You can see that in cell