It is closely related to the COUNTIF function. The COUNTIFS syntaxĬOUNTIFS is a function that allows you to count only those rows in a spreadsheet where certain criteria are met. For example, a Desktop Monitor has been ordered twice, as have Backup Tapes for the Server.
A sample of this data can be seen in the following picture:Īs you can see in this example, there are several examples where the Product and Part Ordered are repeated. We need to identify how often each spare part is being ordered for each machine. Our data table lists orders of spare parts for several computers.
This lesson uses an example of a product order table. Excel offers a number of ways to find rows that contain duplicate values. However, most of them focus on finding rows where the value in just one column is duplicated. In this lesson, we look at how to use the COUNTIFS function to find rows with duplicate entries in two or more columns. We then use the COUNTIFS function in combination with Excel's Conditional Formatting feature to highlight duplicate and triplicate rows.
