What a Pivot Table Computes

A pivot table groups rows and summarizes them — which is exactly what SUMIF, COUNTIF, and AVERAGEIF already do. Build the summary table a pivot table would produce, one formula at a time.