Assalamualaikum wr.wb Oiya yaa bisa juga seperti itu yaa. Knapa pakai lookup yaa. Hehe.haturnuhun om kid.. smoga sehat dan berkah deh buat beexceller khususnya om kid.terima kasih.Hehee Wassalamu'alaikum wr.wb Dikirim dari Yahoo Mail di Android Pada Min, 31 Des 2017 pada 12:09, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb Hai Fahmi, misal hasil di kolom H, record mulai baris 2 Excel =IF(LEN(C2)=0,SUM(C$1:C1)-SUM(H$1:H1),0) Wassalamu'alaikum wr wb Kid 2017-12-31 7:01 GMT+07:00 Fahmi Syaifullah fahmisyaifulla...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: assalamu'alaikum wr.wb selamat pagi agan2 Beexceller.selamat liburan lagi untuk agan2. hehe mau merepotkan lagi om om maaf.mau tanya penetuan cell kosong . gini :cell ada cell tanggal keterangan debet kredit dan saldosaya ingin di kolom kredit berisi nilai atau penumlahan yang adadi kolom cell debet. maaf beexceler dilihat saja file lampirannya. soalnya sulit di kata2 . saya sudah membuat rumus lookup tapi kalau dipikir2 tidak efisien dan membutuhkan banyak look up data ada banyak kalau tidak efisien seperti itu kinerja excel akan semakin lemot. mohon bantuannya beexceler.maaf merepotkan beexceller .. wassalamu'alaikum wr.wb #yiv2353004683 #yiv2353004683 -- #yiv2353004683ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2353004683 #yiv2353004683ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2353004683 #yiv2353004683ygrp-mkp #yiv2353004683hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2353004683 #yiv2353004683ygrp-mkp #yiv2353004683ads {margin-bottom:10px;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad {padding:0 0;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad p {margin:0;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad a {color:#0000ff;text-decoration:none;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ygrp-lc {font-family:Arial;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ygrp-lc #yiv2353004683hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ygrp-lc .yiv2353004683ad {margin-bottom:10px;padding:0 0;}#yiv2353004683 #yiv2353004683actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2353004683 #yiv2353004683activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2353004683 #yiv2353004683activity span {font-weight:700;}#yiv2353004683 #yiv2353004683activity span:first-child {text-transform:uppercase;}#yiv2353004683 #yiv2353004683activity span a {color:#5085b6;text-decoration:none;}#yiv2353004683 #yiv2353004683activity span span {color:#ff7900;}#yiv2353004683 #yiv2353004683activity span .yiv2353004683underline {text-decoration:underline;}#yiv2353004683 .yiv2353004683attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2353004683 .yiv2353004683attach div a {text-decoration:none;}#yiv2353004683 .yiv2353004683attach img {border:none;padding-right:5px;}#yiv2353004683 .yiv2353004683attach label {display:block;margin-bottom:5px;}#yiv2353004683 .yiv2353004683attach label a {text-decoration:none;}#yiv2353004683 blockquote {margin:0 0 0 4px;}#yiv2353004683 .yiv2353004683bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2353004683 .yiv2353004683bold a {text-decoration:none;}#yiv2353004683 dd.yiv2353004683last p a {font-family:Verdana;font-weight:700;}#yiv2353004683 dd.yiv2353004683last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2353004683 dd.yiv2353004683last p span.yiv2353004683yshortcuts {margin-right:0;}#yiv2353004683 div.yiv2353004683attach-table div div a {text-decoration:none;}#yiv2353004683 div.yiv2353004683attach-table {width:400px;}#yiv2353004683 div.yiv2353004683file-title a, #yiv2353004683 div.yiv2353004683file-title a:active, #yiv2353004683 div.yiv2353004683file-title a:hover, #yiv2353004683 div.yiv2353004683file-title a:visited {text-decoration:none;}#yiv2353004683 div.yiv2353004683photo-title a, #yiv2353004683 div.yiv2353004683photo-title a:active, #yiv2353004683 div.yiv2353004683photo-title a:hover, #yiv2353004683 div.yiv2353004683photo-title a:visited {text-decoration:none;}#yiv2353004683 div#yiv2353004683ygrp-mlmsg #yiv2353004683ygrp-msg p a span.yiv2353004683yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2353004683 .yiv2353004683green {color:#628c2a;}#yiv2353004683 .yiv2353004683MsoNormal {margin:0 0 0 0;}#yiv2353004683 o {font-size:0;}#yiv2353004683 #yiv2353004683photos div {float:left;width:72px;}#yiv2353004683 #yiv2353004683photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2353004683 #yiv2353004683photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2353004683 #yiv2353004683reco-category {font-size:77%;}#yiv2353004683 #yiv2353004683reco-desc {font-size:77%;}#yiv2353004683 .yiv2353004683replbq {margin:4px;}#yiv2353004683 #yiv2353004683ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2353004683 #yiv2353004683ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2353004683 #yiv2353004683ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2353004683 #yiv2353004683ygrp-mlmsg select, #yiv2353004683 input, #yiv2353004683 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2353004683 #yiv2353004683ygrp-mlmsg pre, #yiv2353004683 code {font:115% monospace;}#yiv2353004683 #yiv2353004683ygrp-mlmsg * {line-height:1.22em;}#yiv2353004683 #yiv2353004683ygrp-mlmsg #yiv2353004683logo {padding-bottom:10px;}#yiv2353004683 #yiv2353004683ygrp-msg p a {font-family:Verdana;}#yiv2353004683 #yiv2353004683ygrp-msg p#yiv2353004683attach-count span {color:#1E66AE;font-weight:700;}#yiv2353004683 #yiv2353004683ygrp-reco #yiv2353004683reco-head {color:#ff7900;font-weight:700;}#yiv2353004683 #yiv2353004683ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ov li a {font-size:130%;text-decoration:none;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2353004683 #yiv2353004683ygrp-sponsor #yiv2353004683ov ul {margin:0;padding:0 0 0 8px;}#yiv2353004683 #yiv2353004683ygrp-text {font-family:Georgia;}#yiv2353004683 #yiv2353004683ygrp-text p {margin:0 0 1em 0;}#yiv2353004683 #yiv2353004683ygrp-text tt {font-size:120%;}#yiv2353004683 #yiv2353004683ygrp-vital ul li:last-child {border-right:none !important;}#yiv2353004683