SUMIF practice

SUMIF adds the cells in a range that meet one condition. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.

Syntax

SUMIF(range, criterion, [sum_range])

What people get wrong

The range tested and the range summed are different arguments; mixing them up gives a plausible but wrong number.

financial modeling exercise that use SUMIF

• Return on an investment with irregular datesLevel 4Pro

Often used together with: SUM, XIRR