Excel reports: a two-way table, like a PivotTable

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel reports: a two-way table, like a PivotTable

A two-way report has labels down the side and across the top, like a PivotTable. One SUMIFS fills the whole grid with mixed references: $F2 keeps the label column, G$1 keeps the label row, and the data ranges are fully locked.

Key words

$F2
Column locked, row free.
G$1
Row locked, column free.

🔎 What to look for: Test it: copy the formula right and down and check a few cells by hand.

Zero2Hero — Zéro2Héros