• Privacy Policy
  • Disclaimer
  • Contact Us
  • About Us
MAS Al Ahrom Karangsari
  • Home
  • Visi and Misi Madrasah
  • Madrasah Announcements
  • Menu Madrasah
    • GTK MA AL Ahrom Karangsari
    • RDM Madrasah
    • Madrasah News
    • Graduation
    • Structure Organization Madrasah
      • Organizational Structure of the Committee
      • Organizational Structure of Madrasah System
      • Library Organizational Structure
      • Organizational Structure of Computer Laboratories
    • Lessons
    • Learning
      • Madrasah Paramita
      • Madrassah Journal
      • Scientific Papers of Students
      • Learning Articles
    • Facilities and Infrastructure
  • Citizen Madrasah
    • Register
    • Login
    • Password Reset
    • Members
  • ID
No Result
View All Result
MA Al Ahrom Karangsari
No Result
View All Result

Home > Excel and Google Sheets > How to Calculate Cell Tables in Excel 2016 Using SUM Formulas

How to Calculate Cell Tables in Excel 2016 Using SUM Formulas

Admin MAS Al Ahrom by Operator
February 12, 2023
in Excel and Google Sheets

Excel SUM formula – How do you calculate the Excel table? You need to know how to calculate in Excel are commonly used, namely by using the SUM function. Then, what is the SUM function in Excel? In this tutorial, you will learn about the meaning of SUM, how to use the SUM function, some examples of using the SUM formula, and other things that need to know when using the SUM formula in Microsoft Excel.

Understanding Excel’s SUM Function

Before getting too far, let’s learn what the Excel SUM function is. The SUM function is an excel formula that is used to make data calculations or add up all the numbers we specify as arguments. In other words, the use of SUM in Excel is to calculate data or numbers contained in several cells or a specified range.

How to calculate in Excel with the SUM formula can be in the form of ranges, cell references, arrays, constants, formulas, or the results of other functions. This function is one of the most widely known and used Excel functions by every Microsoft Excel user.

In Microsoft Excel, you can not only calculate the data that you have with SUM functions or formulas. You can learn some other alternatives to calculating in Excel on the following page: How to Calculate Data in Excel.

As for basics of learning arithmetic calculations (addition, subtraction, division, and multiplication), please go to the following page: Excel Formulas Addition, Subtraction, Multiplication, and Division Then how do you use the SUM excel function/formula to add the numbers we specify?

How to Use the SUM Function

How to calculate the amount of data with the sum function in Microsoft Excel? namely with the SUM function, this formula in Microsoft Excel is used to add numbers. How to use the sum function to perform summations in Excel is as follows:

 

=SUM(number1;[number2];…)

 

Description of excel SUM function syntax

  • SUM
    Excel function name for calculating in excel
  • number1
    The first number argument we want to count.
  • numbers2
    (Optional) Another number argument we want to calculate. Up to 255 arguments

Example of an Excel SUM formula

Please note some examples of SUM functions in excel below :

Excel 1 SUM Formula Example

contoh rumus excel 1
In the first example above the sum formula used in cell C3 is:

=SUM(A2;A3;A4;A5;A6)

The formula above adds up each value in cells A2, A3, A4, A5, and A6. The result is 360.

Besides using the above formula, you can also sum the range A2:A6 as above with sum formula like this:

=SUM(A2:A6)

The excel formula above adds up each cell value in the range A2: A6. The result is 360.

In the first sum formula, we use each cell reference as an argument of the SUM function. Whereas in the second formula, we use arguments in the form of Range references.

Excel 2 SUM Formula Example

contoh rumus excel 2
In this 2nd example, the sum formula is used to sum a different range of columns.

=SUM(A2:A6;B2:B6)

The formula above adds up each cell value in two different ranges, namely A2:A6 and B2: B6. The result is 710.

If some of these different ranges are not separated by other columns you can also do calculations with formulas like this:

=SUM(A2:B6)

The formula above calculates each cell value in the range A2: B6. The result is 710.

Excel 3 SUM Formula Example

contoh rumus excel 3
In addition to calculating the value of numbers in a cell or range of data. The SUM function can also to calculate several scores from the results of other Excel functions or formulas.

In Cell D3 above, the excel formula used is:

=SUM(MAX(A2:A6);MAX(B2:B6))

In the excel formula above, the MAX function is used to find the highest value from a set of values. The SUM function calculates the maximum (highest) value in the range A2:A6 with the maximum (highest) value in the range B2:B6. the result is 200 + 100 = 300

In the second formula in cell D4, the formula is:

=SUM(MIN(A2:A6);MIN(B2:B6))

In the above formula, the MIN function is used to find the lowest value of a set of values. The SUM function adds the minimum (lowest) value in the range A2:A6 with the minimum (lowest) in the range B2:B6. the result is 25:50 = 75

Important in Using the SUM function

When using the SUM function on an excel formula, there are a few things you need to pay attention to. If the argument in the SUM function is an array or cell/range reference, only the number values in that array or reference are counted. Blank cells, logical values, or text in the array or reference are ignored. Consider the following examples of SUM function formulas:

Rumus Excel SUM error 1

If the argument is an error value or is the text that cannot change to be a number, Microsoft Excel will display an error message.

Rumus Excel SUM error 2

What if you want to add data with criteria or conditions? To form calculations or add numeric values with different values or scores that you want to, then use the SUMIF or SUMIFS function. So, that’s how to use Excel’s SUM function this time. May be useful.

Related Article

simple formulas microsoft excel

Are you confused about Counting Data in Excel? Let’s Get To Know A Simple Formula In Excel!

December 1, 2021
cara menambah dan menyembunyikan lembar kerja excel

How to Print In Microsoft Excel 2016

November 7, 2021
Taking Multiple Characters In Excel ? LEFT MID and RIGHT formulas

Taking Multiple Characters In Excel ? LEFT MID and RIGHT formulas

March 5, 2023
How to Define Rank In Microsoft Excel 2016

How to Define Rank In Microsoft Excel 2016

March 6, 2022
Previous Post

Let’s! Learn Buttons In Microsoft Excel

Next Post

Taking Multiple Characters In Excel ? LEFT MID and RIGHT formulas

Latest Posts

How to Create a Simple Formula For Employee Salary Reports

How to Create a Simple Formula For Employee Salary Reports

by Operator
April 6, 2025
0

In this article, I will provide a tutorial on how to create an employee salary report using the Excel program....

How to Sort Data Using Excel AutoFill Excel 2013

How to Sort Data Using Excel AutoFill Microsoft 2013

by Operator
March 6, 2025
0

Autofill is a feature in Excel that functions to fill in data sequences automatically based on rows or columns and...

Taking Multiple Characters In Excel ? LEFT MID and RIGHT formulas

Taking Multiple Characters In Excel ? LEFT MID and RIGHT formulas

by Operator
March 5, 2023
0

What formulas in Excel are used to retrieve certain letters or words in Excel? When working using Excel, sometimes we...

cara menambah dan menyembunyikan lembar kerja excel

Let’s! Learn Buttons In Microsoft Excel

by Operator
May 8, 2022
0

Excel is a spreadsheet program in the Microsoft Office system. We can use Excel to create and format workbooks to...

How to Solve Duplicate Rankings in Microsoft Excel

How to Solve Duplicate Rankings in Microsoft Excel

by Operator
December 4, 2021
0

As we discussed earlier, define to rank using the excel function with the RANK.AVG, RANK.EQ or RANK formulas still has...

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

I agree to the Terms & Conditions and Disclaimer.

Popular Article

Javanese Exoticism, Diversity of Life and Culture of Javanese People (Part.3)
History

Javanese Exoticism, Diversity of Life and Culture of Javanese People (Part.3)

by Yulianto Wahyu Saputra
November 2, 2022
0

CHAPTER IV Javanese people are said to have lazy characters and there is a need for hard work...

TNI Leadership In History And Struggle - Book Reviews

TNI Leadership In History And Struggle – Book Reviews

by Operator
May 13, 2023
0

Since the beginning of the New Order there has...

Cara Mendapatkan Free Google Cloud Akses Dengan Jenius Card

How to Get Free Google Cloud Access For 12 Months

by Operator
June 11, 2022
0

Google has a promo for its product, Google Cloud...

The Role of Women Makes Batik in Pati - Finish

The Role of Women Makes Batik in Pati – Finish

by Operator
December 17, 2021
0

Women who are professional as a businessman and as...

No Result
View All Result

Categories

How to Print In Microsoft Excel 2016

How to Sort Data Using Excel AutoFill Microsoft 2013

History of Indonesian Batik, From the Age of the Empire to the Republic

Decree of Main Tasks and Functions

Checking Madrasah Operational Assistance Fund by Ministry of Religious

Load More

MA AL Ahrom Karangsari

Our Madrasah was established in 2009, is located on Jalan Nangka No. 45 Karangsari, Karangtengah, Demak.

logo footer ma al ahrom

Our Madrasah

  • Privacy Policy
  • Disclaimer
  • Contact Us
  • About Us

MA AL AHROM’s Social Media

Let's follow every activity of MA AL Ahrom Karangsari on our social media.

© 2021 MA Al Ahrom Karangsari – Design by MA Al Ahrom.

  • ID
No Result
View All Result
  • Home
  • Visi and Misi Madrasah
  • Madrasah Announcements
  • Menu Madrasah
    • GTK MA AL Ahrom Karangsari
    • RDM Madrasah
    • Madrasah News
    • Graduation
    • Structure Organization Madrasah
      • Organizational Structure of the Committee
      • Organizational Structure of Madrasah System
      • Library Organizational Structure
      • Organizational Structure of Computer Laboratories
    • Lessons
    • Learning
      • Madrasah Paramita
      • Madrassah Journal
      • Scientific Papers of Students
      • Learning Articles
    • Facilities and Infrastructure
  • Citizen Madrasah
    • Register
    • Login
    • Password Reset
    • Members

© 2021 MA Al Ahrom Karangsari - Design by MA Al Ahrom.