Loading…
Loading…
When a total looks wrong, check three things: the range (does it cover all rows?), the separators (: means "through", , means "and"), and whether numbers are stored as text (left-aligned, ignored by SUM).
Read the lesson, then try it yourself in a live spreadsheet.