5 alternative reasons to use COUNTIF function

5 alternative reasons to use COUNTIF function

14 June 2015

The COUNTIF function is one of the most useful functions in Excel. Its job is to provide conditional counting. This is primarily used for analysing data and producing reports and dashboards.

In this blog post we look into 5 more unorthodox but useful scenarios for the COUNTIF function to be used. The 5 COUNTIF examples we look at are:

  • Prevent duplicates in a range.
  • Uniquely rank items in a list.
  • Count the unique entries in a list.
  • Compare two lists.
  • Identify names that occur 3 times or more.