When it comes to extracting and analyzing filtered values from souce data, most Excel users turn to the trusty PivotTable. But what if you know exactly how you want to present your data, and need more formatting flexibility than a pivot can accommodate?

In this tip, I’ll show you how to use conditional stats functions like SUMIFS, COUNTIFS and AVERAGEIFS to create your own custom, pivot-style dashboards and reports.

COMMON USE CASES:

• Designing custom-formatted, dynamic reports without using PivotTables
• Filtering or segmenting raw data based on a given set of criteria