Coffee Help
All topics

Help Sums

Totals

MaciPhone and iPad

A line with total, or sum, adds up the numbers above it. average, count, median, min and max work the same way.

A total of the lines above it, and an average.
A total of the lines above it, and an average.

How to add up a list

  1. Write one amount per line.
  2. Under them, write total on a line of its own.
  3. The answer is the sum of the lines above. A blank line starts a new group.

subtotal and grand total add up a part and the whole.

Example

In a note
flights = 420420
hotel = 3 * 95285
food = 150150
total855
bus = 4040
taxi = 2525
total65

The answers appear beside each line and never go into the file.

Totals by tag

Over lines written Label: amount #tag, total #food gives the total for that tag, with average and count too. For example, Lunch: 12 #food and Dinner: 28 #food, then total #food.

Good to know

Selecting numbers, even a table column, shows their sum.

Not what you needed? Write to a person.