Count Tool

This tool is available only in the Menu view spreadsheet.svg Spreadsheet View, and it can be used in two possible ways:

  • Select a destination cell, select the tool, then select a cell range. The count of the number of cells in the range containing data will be displayed in the destination cell.

  • Select a cell range containing more than one cell, then select the tool.

    • If the range has multiple rows, the count of the number of cells in each column containing data will be displayed below each column. If you need to count the cells containing data in each row, hold Shift while selecting the tool: the count for each row will be displayed to the right of the selected data.

    • If the range has only one row, the count of the number of cells in the range containing data will be displayed in the first free cell to the right of the selected data.