SUM

The SUM function in Google Sheets is a foundational tool for adding up a series of numbers, making it indispensable for financial analysis, inventory management, and many other tasks. Whether you're totaling monthly sales, summing up expenses, or calculating the total points in a game, the SUM function is the cornerstone. Dive into our comprehensive guide to harness its capabilities.

Parameters

• value1: The first value or range to be summed.
• value2, ...: [Optional] Additional numbers or ranges to be added.

Step-by-Step Tutorial

1. Using SUM with individual numbers:

   • Example: =SUM(3, 10, 5)
   • Result: 18

2. Using SUM with a range of cells:

   • Example: If A1:A5 has the values 5, 10, 3, 8, 7, then =SUM(A1:A5) will return 33.

Working with a Single Value, a List, and a Range

SUM accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =SUM(A1) — just returns the value in A1.
• List of values: =SUM(A1, A2, A3) — adds each cell individually.
• Range: =SUM(A1:A10) — adds every cell in the range.
• Mixed: =SUM(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Video Example

Use Cases and Scenarios

1. Financial Reporting: Calculate the total revenue over a quarter.
2. Inventory Management: Sum up the total products sold across various categories.
3. Educational Grading: Compute the total score of a student across all subjects.

Related Functions

• SUMIF: Sum the values that meet a specific criterion.
• SUMIFS: Sum values based on multiple criteria.
• SUMPRODUCT: Multiply corresponding components in the given arrays, and then return the sum of those products.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know