Ways to count cells in a range of data Select the cell where you want the result to appear. On the Formulas tab, click More Functions, point to Statistical, and then click one of the following functions: COUNTA: To count cells that are not empty. ... Select the range of cells that you want, and then press RETURN.