cleaning data

Count, sum, average, minimum and maximum

Select some cells and the status bar adds them up, as a spreadsheet does.

Select two cells or more and the status bar shows how many have a value and, of those that are numbers, their sum, their average, the smallest and the largest: Count 12 Sum 1482.5 Average 123.542 Min 8 Max 410.75. Rest the pointer on them to see how many of the cells were numbers, and click a figure to copy it.

The column population selected from the column bar, shaded from row 2 down, and the status bar below: Column selected, Count 8, Sum 211723000, Average 26465375, Min 21673000, Max 37115000
  • To total a column, click its number in the column bar above the rows; drag over several numbers to total several columns.
  • To total part of a column, or a few columns at once, select a box: Alt+Shift+Drag⌥⇧Drag, or a drag in Column Selection Mode.
  • Selecting whole rows adds up every number in them.

What counts:

  • Empty cells and missing values (NA, null, -…) aren’t counted at all.
  • Each number is read with its column’s decimal separator, so a file with decimal commas adds up right, and the results are written the same way. Currency symbols, units and percentages are set aside: $12 counts as 12.
  • Values that aren’t numbers are counted but not added.
  • The sum, the minimum and the maximum have as many decimals as the values; the average two more, up to six.

The figures are worked out as you change the selection, for selections of up to a few million characters; past that, the status bar leaves them out.