Introduction
The SUM function adds numbers together quickly. It helps you total values in a list or range without adding each number by hand.
When you want to add all sales amounts in a column to find the total sales.
When you need to calculate the total expenses from a list of costs.
When you want to add up scores from multiple tests to get a final score.
When you want to sum hours worked each day to find total hours for the week.
When you want to add values from different cells without typing each number.