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.
