Cara Mudah Menjumlahkan Secara Otomatis Di Microsoft Excel

Discussion in 'General Internet' started by Dede P, Nov 8, 2014.

  1. Dede P

    Dede P Member

    Joined:
    Nov 4, 2014
    Messages:
    40
    Likes Received:
    2
    Trophy Points:
    8
    Cara Menjumlahkan Otomatis Dengan Excel

    1. Masukkan angka-angka atau data kedalam table atau sel-sel di lembar kerja ms excel. Seperti contoh gambar berikut ini
    [​IMG]

    2. Blok sel yang berisi angka-angka sampai pada sel dimana hasil penjumlahan akan ditampilkan, misalnya sampai pada baris JUMLAH.
    [​IMG]

    3. Setelah itu klik icon Auto Sum pada ribbon Home, group menu editing
    [​IMG]

    4. Maka hasil penjumlahan secara otomatis akan ditampilkan dengan akurat.

    [​IMG]

    Penjumlahan otomatis ini dapat dilakukan secara vertical atau kolom dan bisa juga dilakukan secara horizontal atau baris. Itulah Cara melakukan penjumlahan secara otomatis menggunakan Microsoft Excel 2007. Semoga bermanfaat

    Sumber: Cara Penjumlahan Secara Otomatis di Excel
    Shoes
     
  2. pram

    pram Well-Known Member

    Joined:
    Sep 23, 2013
    Messages:
    3,099
    Likes Received:
    161
    Trophy Points:
    63
    Google+:
    Wah makasih om Tipsnya, kebetulan nih Kali saya lagi belajar microsoft exel di sekolah :D
     
  3. exabytes-id

    exabytes-id Member

    Joined:
    Oct 3, 2013
    Messages:
    866
    Likes Received:
    35
    Trophy Points:
    28
    Ini hanya berlaku di Ms. OFFICE 20017 kah ?
     
  4. Devita

    Devita Active Member

    Joined:
    Oct 11, 2014
    Messages:
    1,196
    Likes Received:
    43
    Trophy Points:
    48
    Google+:
    Versi masa depan itu mas hehehe
     
  5. exabytes-id

    exabytes-id Member

    Joined:
    Oct 3, 2013
    Messages:
    866
    Likes Received:
    35
    Trophy Points:
    28
    maksud ane 2007 gan *ketawa4*
     
  6. rajautan

    rajautan Active Member

    Joined:
    Mar 21, 2015
    Messages:
    1,354
    Likes Received:
    57
    Trophy Points:
    48
    Monggo di coba,,, kalau untuk membuat rata-ratanya juga share Den,,,
     
  7. Surur12

    Surur12 Member

    Joined:
    Sep 25, 2015
    Messages:
    250
    Likes Received:
    10
    Trophy Points:
    18
    jadi mengingatkanku nzaman SMA dulu belajar Excel....
     
  8. DonMafioso

    DonMafioso New Member

    Joined:
    Oct 27, 2015
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Well, dlu ane pas bljr Excel, klo ad rumus itung2an gt misal nyari jumlah, kadang ane ngitung per baris ato kolom, kadang juga ane pake Autosum. Tapi klo mnrt ane sih Autosum emank lbh simple sih :D
     
  9. jokosatriopermana

    jokosatriopermana Member

    Joined:
    Dec 30, 2015
    Messages:
    192
    Likes Received:
    5
    Trophy Points:
    18
  10. aanweb

    aanweb New Member

    Joined:
    Feb 28, 2017
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    wahhh ini yang lagi saya cari, ternyata ketemu di sini, udah lama lagi
    makasih
     
  11. walatraherbal

    walatraherbal Member

    Joined:
    May 17, 2018
    Messages:
    197
    Likes Received:
    8
    Trophy Points:
    18
    memang ms excel sangat membantu dalam pekerjaan saya, makasih infonya*yess*
     
  12. agam

    agam Member

    Joined:
    May 30, 2018
    Messages:
    213
    Likes Received:
    3
    Trophy Points:
    18
    Ilmu baru nih,... thanks ya....
     
Loading...

Share This Page