Sama2, sy juga baru kenal sumproduct dari grup ini.... Salam,HK Sent from Yahoo Mail on Android On Fri, Jul 28, 2017 at 11:54, 'CepWahyu' [email protected] [belajar-excel]<[email protected]> wrote:
Wokeh bang…thanks elmunya. Regards CW From: [email protected] [mailto:[email protected]] Sent: Jumat, 28 Juli 2017 09.47 To: 'CepWahyu' [email protected] [belajar-excel] <[email protected]> Subject: Re: RE: RE: [belajar-excel] Manfaat Table untuk Function (mis. Sumproduct) Hai CW, Blok datanya, lalu klik Insert Table (di Excel 2013 saya). Salam, HK On Friday, July 28, 2017, 9:18:57 AM GMT+7, 'CepWahyu' [email protected] [belajar-excel] <[email protected]> wrote: Cakep bang… Itu bikin table kaya gitu gmn caranya ya bang?....serius nanya nih bang…maklum ilmu excelnya masih standar. Regrds CW From: [email protected] [mailto:[email protected]] Sent: Kamis, 27 Juli 2017 14.21 To: 'CepWahyu' [email protected] [belajar-excel] <[email protected]> Subject: Re: RE: [belajar-excel] Manfaat Table untuk Function (mis. Sumproduct) Betul. Jika kita coba tambah data, akan terasa manfaatnya kan ? Krn ga perlu update function Sumproductnya lagi. Salam, HK On Thursday, July 27, 2017, 1:49:52 PM GMT+7, 'CepWahyu' [email protected] [belajar-excel] <[email protected]> wrote: Ini hasil sy otak atik bang…..apakah sudah benar? Best Regards CW From: [email protected] [mailto:[email protected]] Sent: Kamis, 27 Juli 2017 11.04 To: BeExcel <[email protected]> Subject: [belajar-excel] Manfaat Table untuk Function (mis. Sumproduct) [1 Attachment] Dear Be-Excel, Coretan kecil ini saya tujukan untuk member Be-Excel yang jarang menggunakan function Sumproduct (termasuk saya). Sumproduct adalah "array formula (function)" yang penulisannya tidak perlu Array (ada tanda "{}"), walaupun dalam penjelasan penulisannya "=Sumproduct(array1, [array2, [array3], .....)". Satu hal yang "berbeda" dari Sumproduct adalah penggunaan tanda kali ("*") sebagai tanda pemisah bukan tanda koma (",") untuk Regional selain Indonesia atau tanda titik koma (";") untuk Regional Indonesia. Penulisan array1, array2 dstnya selalu mengacu pada Range Acuan = Cell. Agar formula Sumproduct dapat dicopy tentunya Range Acuan tersebut harus diberi tanda "$" dengan menekan tombol F4, sehingga setiap kali range yang menjadi acuan berubah maka penulisan Range Acuan pada Sumproduct harus diubah pula, Solusi untuk mengatasi hal tersebut adalah menggunakan Table sebagai Range Acuan dengan cara memblok range yang menjadi acuan kemudian menggantinya menjadi Table (Insert Table). Setelah function Sumproduct mengacu pada Table, jika ada tambahan data maka penulisan Range Acuan (Table) dalam Sumproduct tidak perlu diubah lagi. Untuk lebih memahami/mendalami penggunaan Sumproduct, silakan gunakan function Sumproduct untuk menentukan harga satuan pada file terlampir, dimana Range Acuannya sdh berupa Table. Selamat mencoba. Salam, HK #yiv7894835719 #yiv7894835719 -- #yiv7894835719ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7894835719 #yiv7894835719ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7894835719 #yiv7894835719ygrp-mkp #yiv7894835719hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7894835719 #yiv7894835719ygrp-mkp #yiv7894835719ads {margin-bottom:10px;}#yiv7894835719 #yiv7894835719ygrp-mkp .yiv7894835719ad {padding:0 0;}#yiv7894835719 #yiv7894835719ygrp-mkp .yiv7894835719ad p {margin:0;}#yiv7894835719 #yiv7894835719ygrp-mkp .yiv7894835719ad a {color:#0000ff;text-decoration:none;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ygrp-lc {font-family:Arial;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ygrp-lc #yiv7894835719hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ygrp-lc .yiv7894835719ad {margin-bottom:10px;padding:0 0;}#yiv7894835719 #yiv7894835719actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7894835719 #yiv7894835719activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7894835719 #yiv7894835719activity span {font-weight:700;}#yiv7894835719 #yiv7894835719activity span:first-child {text-transform:uppercase;}#yiv7894835719 #yiv7894835719activity span a {color:#5085b6;text-decoration:none;}#yiv7894835719 #yiv7894835719activity span span {color:#ff7900;}#yiv7894835719 #yiv7894835719activity span .yiv7894835719underline {text-decoration:underline;}#yiv7894835719 .yiv7894835719attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7894835719 .yiv7894835719attach div a {text-decoration:none;}#yiv7894835719 .yiv7894835719attach img {border:none;padding-right:5px;}#yiv7894835719 .yiv7894835719attach label {display:block;margin-bottom:5px;}#yiv7894835719 .yiv7894835719attach label a {text-decoration:none;}#yiv7894835719 blockquote {margin:0 0 0 4px;}#yiv7894835719 .yiv7894835719bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7894835719 .yiv7894835719bold a {text-decoration:none;}#yiv7894835719 dd.yiv7894835719last p a {font-family:Verdana;font-weight:700;}#yiv7894835719 dd.yiv7894835719last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7894835719 dd.yiv7894835719last p span.yiv7894835719yshortcuts {margin-right:0;}#yiv7894835719 div.yiv7894835719attach-table div div a {text-decoration:none;}#yiv7894835719 div.yiv7894835719attach-table {width:400px;}#yiv7894835719 div.yiv7894835719file-title a, #yiv7894835719 div.yiv7894835719file-title a:active, #yiv7894835719 div.yiv7894835719file-title a:hover, #yiv7894835719 div.yiv7894835719file-title a:visited {text-decoration:none;}#yiv7894835719 div.yiv7894835719photo-title a, #yiv7894835719 div.yiv7894835719photo-title a:active, #yiv7894835719 div.yiv7894835719photo-title a:hover, #yiv7894835719 div.yiv7894835719photo-title a:visited {text-decoration:none;}#yiv7894835719 div#yiv7894835719ygrp-mlmsg #yiv7894835719ygrp-msg p a span.yiv7894835719yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7894835719 .yiv7894835719green {color:#628c2a;}#yiv7894835719 .yiv7894835719MsoNormal {margin:0 0 0 0;}#yiv7894835719 o {font-size:0;}#yiv7894835719 #yiv7894835719photos div {float:left;width:72px;}#yiv7894835719 #yiv7894835719photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7894835719 #yiv7894835719photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7894835719 #yiv7894835719reco-category {font-size:77%;}#yiv7894835719 #yiv7894835719reco-desc {font-size:77%;}#yiv7894835719 .yiv7894835719replbq {margin:4px;}#yiv7894835719 #yiv7894835719ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7894835719 #yiv7894835719ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7894835719 #yiv7894835719ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7894835719 #yiv7894835719ygrp-mlmsg select, #yiv7894835719 input, #yiv7894835719 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7894835719 #yiv7894835719ygrp-mlmsg pre, #yiv7894835719 code {font:115% monospace;}#yiv7894835719 #yiv7894835719ygrp-mlmsg * {line-height:1.22em;}#yiv7894835719 #yiv7894835719ygrp-mlmsg #yiv7894835719logo {padding-bottom:10px;}#yiv7894835719 #yiv7894835719ygrp-msg p a {font-family:Verdana;}#yiv7894835719 #yiv7894835719ygrp-msg p#yiv7894835719attach-count span {color:#1E66AE;font-weight:700;}#yiv7894835719 #yiv7894835719ygrp-reco #yiv7894835719reco-head {color:#ff7900;font-weight:700;}#yiv7894835719 #yiv7894835719ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ov li a {font-size:130%;text-decoration:none;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7894835719 #yiv7894835719ygrp-sponsor #yiv7894835719ov ul {margin:0;padding:0 0 0 8px;}#yiv7894835719 #yiv7894835719ygrp-text {font-family:Georgia;}#yiv7894835719 #yiv7894835719ygrp-text p {margin:0 0 1em 0;}#yiv7894835719 #yiv7894835719ygrp-text tt {font-size:120%;}#yiv7894835719 #yiv7894835719ygrp-vital ul li:last-child {border-right:none !important;}#yiv7894835719
