Türk İngilizce
TOPLA SUM

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.

Employee Salary
Ahmet 3000
Burak 4000
Ceyda 3500
  =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:

Product Revenue
Red Sweater 120
Blue Shirt 200
Green Pants 150
  =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

Diğer fonksiyonlar
Bir sayının kosinüsünü verir
Bir sayının hiperbolik kosinüsünü verir
Bir sayının hiperbolik kosinüsünü verir
Bir açının kotanjantını verir