3 August 2013
SUMIF and PivotTables can both summarize data based on specific criteria, but they do so in completely different ways.
In most cases, PivotTables are going to be faster and easier to get the data that you want, but sometimes using Excel formulas is the only way to handle complicated data.
Full article: When to use SUMIF vs. Pivot Tables in Excel
