Summing, multiplying, and dividing numeric columns

To sum two or more columns together:

  1. In the Summary view, select the columns you wish to sum by Command-clicking or shift-clicking
  2. Choose Column > Sum Columns

To subtract one column from another:

  1. In the Summary view, select the column you wish to subtract from (the minuend)
  2. Choose Column > Subtract, and choose the name of the column you wish to subtract (the subtrahend)

To multiply a column by another column:

  1. In the Summary view, select the column you wish to multiply
  2. Choose Column > Multiply By, and choose the name of the other column

To divide a column by another column:

  1. In the Summary view, select the column to be divided (the dividend)
  2. Choose Column > Divide By, and choose a column you wish to divide by (the divisor)

By default, the names of the resulting columns to reflect the underlying formulas, but you can change them to other names of your choosing. Note that changing the name will not affect the formula used to compute the column.

See also:

Back to Wizard Help