Duplicates aren't bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here's how to tackle these tasks in Excel.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Input the ROWS function into that cell using the first and last cells of that column, not including the column heading. After that, you will know how many unique values are in that column.

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.