5 Alternative Reasons to Use COUNTIF Function

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 will look into 5 more unorthodox but useful scenarios for the COUNTIF function to be used. The 5 COUNTIF examples we look at are;

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

Continue reading

Count Unique Values in a PivotTable

When using a PivotTable to summarise a large list of data, you may need to count unique occurrences in a particular field.

For example, you may have a list of data like the one below and want to count the number of different customers in each country, or the number of different products that were sold in each country.

List of data to count uniques

If you added the Customer Name field to the Values area of a PivotTable and summarised it with a Count you would get the result below.

Counting values in a PivotTable

However this is counting all of the transactions in each country. We need to count the unique customers making those transactions in each country.

Continue reading