SUM practice

SUM adds its arguments, ignoring text and empty cells. Below are the 10 financial modeling exercises on Modeldrill 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.

financial modeling exercises that use SUM

• Revenue mix by productLevel 1Pro
• Straight-line depreciation by assetLevel 2Pro
• Cash roll-forwardLevel 3Pro
• Discount factors and present valuesLevel 4Pro
• Mid-year convention switchLevel 4Pro
• Terminal value by perpetual growthLevel 4Pro
• Dated cash flows with XNPV and XIRRLevel 4Pro
• Return on an investment with irregular datesLevel 4Pro
• Payback periodLevel 5Pro
• Cohort payback by monthLevel 5Pro

Often used together with: COUNTIF, IF, INDEX, SUMIF, XIRR, XNPV