Ways to count values in a worksheet | Microsoft Support Use AutoSum by selecting a range of cells that contains at least one numeric value Then on the Formulas tab, select AutoSum > Count Numbers Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected