Excel reports: a summary table

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 summary table

A good report is built from one formula copied down. The label column holds the categories; the formula points to the label cell and locks the data ranges with $, like =SUMIF($B$2:$B$11, E2, $C$2:$C$11).

Key words

Label cell
Unlocked, so it moves with each row.
Data ranges
Locked, so they stay put.

🔎 What to look for: Never type a category name inside a report formula; point to its label.

Zero2Hero — Zéro2Héros