5 Reasons to use COUNTIF - #4 Create a Distinct Count Formula

Create a distinct count of values in Excel using the COUNTIF function. Counting formulas are very popular in Excel, however, it does not have one to count the unique values only, known as a distinct count. This video tutorial demonstrates how you can create a distinct count in Excel by using the COUNTIF function with SUMPRODUCT. The example shows counting the unique visitors to an event as opposed to the total number of visitors. How this distinct count formula in Excel works is fully explained in the video. The SUMPRODUCT function plays a key role in totalling the count of unique values. This video is the fourth in the '5 Alternative Reasons to use COUNTIF' series. The COUNTIF function in Excel is used to count records that meet specific criteria. It is one of the most useful functions in Excel, especially for analysing data and reporting. This video series looks at 5 alternative reasons to use the COUNTIF function. The other videos in the series can be found using the links below. #1 – Prevent Duplicate Entries in a Range - https://youtu.be/N2WV_rO_y2s #2 - Uniquely Rank Items in a List - https://youtu.be/QFdsGGlSmrU