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.

67d1273429211howquicklycountdatavalues Excel 2010: How To Quickly Count Data ValuesView in gallery

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

68d1273429215howquicklycountdatavalues Excel 2010: How To Quickly Count Data ValuesView in gallery