Using Excel Countif function and Sumproduct - High level information

Using some basic functions you can show highlevel data very quickly. In this video I go through using the Countif function along with the Sumproduct function. Whilst the data set is small in size this can be applied to larger data sets.