You might be wondering how to count the unique items in column D if you don’t have the unique list in column H. Please don’t work that hard.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.