## Selecting Cells in a Spreadsheet

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.

- To total a column, click its number in the [column bar](/content/help/editing/selecting-columns-and-rows/index.html#whole-columns) 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](/content/help/editing/selecting-columns-and-rows/index.html#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.
