i-nth - When to use SUMIF vs. Pivot Tables in Excel

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

Essential reading

Spreadsheet errors: What we know; what we think we can do

Research concludes unanimously that spreadsheet errors are both common and non-trivial. We must seek ways to reduce spreadsheet errors.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.