Using the SUM Function

The SUM function is highly prevalent in MS Excel and Google Sheets for calculating the total sum of specified ranges or series of numbers. The following details and examples will guide you on how to utilize this function effectively.

Syntax and Parameters

The basic structure of the SUM function is as follows:

  SUM(number1, [number2, ...])  

• number1, number2, … – These parameters represent the numbers or ranges to be summed. A range can be specified as a column or row or by entering numbers directly.

Example: To calculate the total of the first five cells in the first column, you can use the following formula:

  =SUM(A1:A5)  

In this example, numbers in cells from A1 to A5 are added together.

Practical Usage Scenarios

1. Calculating Payroll Budgets

To sum up the salaries of employees in a department, the SUM function can be employed to prepare a payroll budget.

  =SUM(B2:B4)  

Here, the total payroll budget is calculated by summing the salaries in cells B2 to B4.

2. Calculating Total Revenue for Sales Reports

Use the SUM function to calculate total revenue from various products in a store. The products and their corresponding revenues might be listed as follows:

  =SUM(B2:B4)  

The formula above sums the revenues listed in cells B2 to B4, providing a summary that could be reported as an overall sales total.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/topla-işlevi-043e1c7d-7726-4e80-8f32-07b23e057f89