Pivot table
An Excel table that sums and groups the rows of the source data by chosen fields on its own without formulas.
Formula
rows = groups, values = the sum or average of a field
How to read
The source data must be a flat table with headers and no merged cells; after editing data the pivot is refreshed.