• 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 > Are you confused about Counting Data in Excel? Let’s Get To Know A Simple Formula In Excel!

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

Admin MAS Al Ahrom by Operator
December 1, 2021
in Excel and Google Sheets

What should you do? If you are faced with so many table number data in Excel. Relax, we can solve it easily and quickly if we know-how. It should one of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this chapter, we will discuss how to use cell references to create simple formulas.

A. MATHEMATICS OPERATOR

Excel uses standard formula operators, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a slash for division (/), and a caret (^) for exponents or rank. All formulas in Excel must start with an equal sign (=). It is because cells contain are formulas and values to be calculated..

B. UNDERSTANDING CELL REFERENCES
Although we can create simple formulas in Excel using numbers (for example, = 2 + 2 or = 5 * 5), mostly we will use cell addresses when creating formulas. It is known as a cell reference. Using cell references will ensure that your formulas are always accurate because you can change the value of the referenced cell without having to rewrite the formula. Example on the formula below, cell A3 is the sum of cells A1 and A2 by making cell references:

A Simple Formula In Excel

When you press Enter, the formula will calculate and display the answer from cell A1 + cell A2 (5 + 2) in cell A3 (7)

A Simple Formula In Excel

If the values in the cell precisely changed to example 5 are changed to 6 the formula will recalculate automatically:

mengubah data penjumlahan excel 2016

How easy is it? Okay, now we continue to deepen our learning about this Excel formula with a lot of data, let’s take a look more.

C. CREATE A FORMULA WITH A SIMPLE CASE:
In our example below, we’ll use a simple formula and cell reference to calculate the budget for the Saturday night camp activity of Scouts Group, called Persami.

A Simple Formula In Excel

1. Select the cells that will contain the formula. In our example, we’ll select cell D7

menghitung jumlah data excel 2

2. Type an equal sign = B7 * C7 because we are multiplying the contents in cell B7 by C7. Notice this formula will appear in the cell and formula bar.

menghitung jumlah data excel 3

3. Press Enter on your keyboard. The formula will be calculated, and the value will be displayed in the cell. If you select the cell again, note that the cell displays will give you the result, while the formula bar will be displays of the formula.

menghitung jumlah data excel 4

D. COPYING THE FORMULES INTO ALL TABLE DATA

There are several options to copy formulas between cells, such as:

1. Copy > Paste

a. Click the cell to be copied> right mouse click> click copy

COPYING THE FORMULES INTO ALL TABLE DATA

b. Select the cell in which to place the formula

menyalin rumus excel 1b

c. Clicking paste will generate the same reference formula

menyalin rumus excel 1c

2. Copy the formula with the fill handle

Formulas can also be copied to adjacent cells using the fill handle, which can save you a lot of time and effort if you want to perform the same calculation multiple times in a worksheet. The fill handle is the small square in the lower right corner of the selected cell.

a. Select the cells containing the formula you want to copy. Click and drag the fill handle through the cells you want to fill:

Copy the formula with the fill handle

b. After you release the mouse, the formula will be pasted to the selected cells

menyalin fill series rumus excel 2b

Now you could know, how to add data in Excel using the above method … the above formula can also be replaced by addition (+), minus sign for subtraction (-), slash for division (/), and a caret ( ^) for data with the sum of powers. Thus from us, Thank you and share it on your social media so that this knowledge can be useful for many other people.

Related Article

How to Sort Data Using Excel AutoFill Excel 2013

How to Sort Data Using Excel AutoFill Microsoft 2013

March 6, 2025
How to Create a Simple Formula For Employee Salary Reports

How to Create a Simple Formula For Employee Salary Reports

April 6, 2025
cara menambah dan menyembunyikan lembar kerja excel

How to Print In Microsoft Excel 2016

November 7, 2021
cara menambah dan menyembunyikan lembar kerja excel

Let’s! Learn Buttons In Microsoft Excel

May 8, 2022
Previous Post

How to Find Average, Maximize, and Minimize Score in Microsoft Excel 2016

Next Post

How to Make Charts or Graph on Google Spreadsheets. Quick And Easy!

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 Menjumlahkan Data Pada Excel 2016 Menggunakan Rumus SUM

How to Calculate Cell Tables in Excel 2016 Using SUM Formulas

by Operator
February 12, 2023
0

Excel SUM formula - How do you calculate the Excel table? You need to know how to calculate in Excel...

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...

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

The Role of Sociology in Human Physical and Spiritual Health
Sociology

The Role of Sociology in Human Physical and Spiritual Health

by Suliyah
June 4, 2022
0

CHAPTER I INTRODUCTION Early Writing It is well known that the physical environment plays an important role in...

metode pengobatan tradisional

Traditional Medicine Benefits Of Spices in Indonesia

by Operator
April 8, 2022
0

SCIENTIFIC PAPERS Traditional Medicine Methods This report was submitted...

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

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

by Operator
December 22, 2021
0

Today, Batik is in a time of popularity. Batik...

Logo default ma al ahrom placeholder

Cultivation of Coro Herbs in Rejosari Village

by Operator
June 4, 2022
0

Budidaya Jamu Coro Di Desa Rejosari Bisa di download...

No Result
View All Result

Categories

Physical Evidence of the Glory of Cirebon Elders

Basic Volleyball Techniques You Should Know

Role of Religious Pluralism in National and State of Indonesia

Papers of Mao Ze Dong, China’s Leader during the Physical Revolution

Basics Equipment of Basketball Training Requirements

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.