Row totaling adds or subtracts amounts in other rows. A totaling formula can include the + and - operators to combine any combination of individual row codes and ranges (indicated by a :). The formula can be up to 1024 characters long.
Examples of standard totaling formulas include the following:400+420+430+450+460LIABILITIES+EQUITY520:546520:546-LIABILITIES
A total formula can include row codes for rows from anywhere in the current row definition, regardless of their location or inclusion in another total. Total rows and amount rows can be used in any combination.
Note: All total rows that fall within a range are automatically excluded, which means that you can create a grand total by specifying the entire range of rows regardless of any intermediate subtotals. However, if first row of a range is a total, that row is included in the new total.
Given below is the procedure to create a row total:
Double-click the Format Code cell in the row definition, and then select TOT.
In the Related Formulas/Rows/Units cell, type the total formula.