Independent practice · Spreadsheet

Fix line item calculations

Your work

Active 0:00 · Paused 0s

Edit the grid or the CSV. Formulas use grid row numbers, including the header row.

Business key

Supported formulas

SUM, SUMIF, COUNTIF, IF, TRIM and exact LOOKUP. Arithmetic, single-column ranges and cell references are supported. Example: =SUM(B2:B3). Cycles are rejected. Empty numeric values stay empty unless you supply a declared default.

CSV answer

Import answer

Show the reference answer

sku,quantity,unit_price,line_total
PEN,2,3,6
MUG,1,12,12

The PEN total should be 6, not 5.