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.
