Excel·35 min

SUM, IF, and references: calculate and classify automatically

Calculate completion rates and differences, total quantities, and apply a clear condition with a fixed reference whose value can change without rewriting formulas.

The ideaThe stepsThe videoPracticeQuiz
The idea1 / 13

What are we solving today?

A formula links its result to source cells instead of storing a fixed answer, so the result changes when the data changes. A relative reference adapts when a formula is copied, while an absolute reference preserves the location of a shared setting such as a completion threshold.

After this stop…

Calculate completion rates and differences, total quantities, and apply a clear condition with a fixed reference whose value can change without rewriting formulas.

One step at a time. Your progress stays on your device.