Summary formula cell name

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


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.

Row formula cell 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

Screenshot of Department XLS template file


You can see that in cell