All functions / Math

SUM

Adds up numbers, cells and ranges.

Syntax

=SUM(number1, [number2], …)

Arguments

• number: A number, cell or range to add.

Example

=SUM(A1:A5) → Total of A1 through A5

Practise it

• SUM and AutoSum
• Counting cells
• Copying formulas with the fill handle
• Mixed references
• Percentages and number formats
• Comparisons: TRUE or FALSE
• SUMPRODUCT
• Formatting numbers in text with TEXT
• Rounding values (not just how they look)
• Timesheets and hours worked
• Build a loan amortization schedule
• Editing without the mouse
• Formatting and finishing touches
• Challenge: quarterly sales summary
• Challenge: stock room reorder list
• Challenge: travel budget vs actual