SUM practice

SUM adds its arguments, ignoring text and empty cells. Below are the 6 Google Sheets exercises on Sheetsdrill 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.

Google Sheets exercises that use SUM

• Total ad spendLevel 1Free
• Sum a filtered listLevel 4Pro
• Top three deals with SORTNLevel 4Pro
• Revenue with ARRAYFORMULALevel 4Pro
• Codes that are too longLevel 4Pro
• Valid order IDsLevel 5Pro

Often used together with: ARRAYFORMULA, FILTER, IF, LEN, REGEXMATCH, SORTN