Excel 2010: How To Quickly Count Data Values

Count Numbers function in Excel 2010 greatly helps in quickly counting number of occurrences in specified range. This post covers counting a list of data cells using this function.

For counting values in column or row, select the range with an extra cell for displaying the result and navigate to Formulas tab, under Under AutoSum option, click Count Numbers.


It will instantly count the data values in selected fields or row and show the result.