How to Summarise Data with SUMIF()

Some of the best functions in Excel are those that help to make sense of indigestible large data sets. One function, which is great at helping turn data into insight, is SUMIF(): a powerful function that adds up numbers across categories. Imagine you are in charge of three shops selling...