SUM practice

SUM adds its arguments, ignoring text and empty cells. Below are the 4 Excel exercises on Formuladrill that use it, each checked instantly in your browser.

Syntax

SUM(value1, [value2], ...)

What people get wrong

A range such as B2:B6 keeps working when a number inside it changes; a list of single cells does not grow with the data.

Excel exercises that use SUM

• Add it upLevel 1Free
• Running totalLevel 1Pro
• Numbers stored as textLevel 6Pro
• The budget that looks fineLevel 7Free

Often used together with: VALUE