Cara Menggunakan Fungsi Sum di Microsoft Excel

Unduh PDF
Unduh PDF

Menggunakan fungsi SUM di Excel adalah cara termudah untuk menghemat waktu Anda.

Metode 1
Metode 1 dari 3:

Menulis Formula Sum

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/41\/Use-the-Sum-Function-in-Microsoft-Excel-Step-1-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Use-the-Sum-Function-in-Microsoft-Excel-Step-1-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Putuskan kolom angka atau kata yang ingin ditambahkan
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b3\/Use-the-Sum-Function-in-Microsoft-Excel-Step-2-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b3\/Use-the-Sum-Function-in-Microsoft-Excel-Step-2-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Use-the-Sum-Function-in-Microsoft-Excel-Step-3-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-3-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Use-the-Sum-Function-in-Microsoft-Excel-Step-3-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Seperti ini: =SUM.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/85\/Use-the-Sum-Function-in-Microsoft-Excel-Step-4-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/Use-the-Sum-Function-in-Microsoft-Excel-Step-4-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Seperti ini: =Sum(A2:A4).
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8f\/Use-the-Sum-Function-in-Microsoft-Excel-Step-5-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/Use-the-Sum-Function-in-Microsoft-Excel-Step-5-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Excel akan menjumlahkan angka dalam sel A2 hingga A4.
    Iklan
Metode 2
Metode 2 dari 3:

Menggunakan AutoSum

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/66\/Use-the-Sum-Function-in-Microsoft-Excel-Step-6-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/66\/Use-the-Sum-Function-in-Microsoft-Excel-Step-6-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik ke dalam sel pada akhir daftar yang ingin Anda tambahkan (di bawah atau di samping nomor yang diberikan).
    • Pada Windows, tekan Alt dan = di waktu bersamaan.
    • Pada Mac, tekan Command dan Shift dan T di waktu bersamaan.
    • Atau di komputer mana pun, Anda dapat memilih tombol Autosum dari menu/pita Excel.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5d\/Use-the-Sum-Function-in-Microsoft-Excel-Step-7-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-7-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5d\/Use-the-Sum-Function-in-Microsoft-Excel-Step-7-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/86\/Use-the-Sum-Function-in-Microsoft-Excel-Step-8-Version-4.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-8-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Use-the-Sum-Function-in-Microsoft-Excel-Step-8-Version-4.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Iklan
Metode 3
Metode 3 dari 3:

Menyalin Fungsi Sum ke Kolom Lain

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f3\/Use-the-Sum-Function-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f3\/Use-the-Sum-Function-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jika ada beberapa kolom yang akan menambahkan, tempatkan kursor tetikus ke kanan bawah sel yang baru saja selesai dijumlahkan. Kursor akan berubah menjadi tanda plus hitam tebal.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Use-the-Sum-Function-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Use-the-Sum-Function-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a1\/Use-the-Sum-Function-in-Microsoft-Excel-Step-11-Version-3.jpg\/v4-460px-Use-the-Sum-Function-in-Microsoft-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a1\/Use-the-Sum-Function-in-Microsoft-Excel-Step-11-Version-3.jpg\/v4-728px-Use-the-Sum-Function-in-Microsoft-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Excel akan mengisi otomatis sisa formulanya!
    Iklan

Tips

  • Begitu Anda mulai mengetik setelah tanda =, Excel akan menunjukkan daftar tarik-turun fungsi-fungsi yang tersedia. Klik sekali dengan tombol kiri tetikus, dalam hal ini, pada SUM untuk menyorotnya.
  • Gunakan titik dua menggantikan kata TO, misalnya, B4 TO B7.
Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara Mudah Membuat Tanda Panah di Word pada Komputer Windows atau Mac
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 95.550 kali.

Apakah artikel ini membantu Anda?

Iklan