Dear Cety,
Formula tersebut di tempatkan di cell b2 pada sheet "Umum"
TerimaKasih
Pada Jumat, 17 Februari 2017 13:50, "cetycarmelo7713 [email protected]
[belajar-excel]" <[email protected]> menulis:
Mohon maaf bang toby saya bingung jadinya. Setelah saya masukkan rumus
yang bang toby kasih ke sheet januari cell b2, hasilnya 0 bang. Dan saya jadi
tambah bingung karena kurang paham rumusnya. Gimana kalau dikembangkan dari
rumus yang saya punya bisa gak ya? Tetapi rumus yang punya saya benar hanya
untuk tahun 2017, kalau tahun 2018 jadinya salah karena data diambil dari bulan
desember 2017. Rumus yang saya maksud pada sheet B2
|
=IF($D$2=2016,B3+SUMIFS(basedata!D:D,basedata!B:B,"Awal",basedata!C:C,januari!A3),0)
|
Nilai false (0) itu yang saya bingung harus masukkan apa.
Maaf sangat merepotkan.
On 15-02-2017 8:19 PM, Toby kenzo [email protected] [belajar-excel] wrote:
Dear Cety, Coba gunakan formula ini di cell B2 :
=IFERROR(INDEX(basedata!$D$2:$D$30,MATCH(1,(umum!A2=basedata!$C$2:$C$30)*(umum!$H$2=basedata!$A$2:$A$30)*(umum!$I$2=basedata!$B$2:$B$30),0)),0)
karena Array formula, jangan lupa tekan ctrl+shift+enter sesudah memasukan
formula di cell tersebut. TerimaKasih.
Pada Rabu, 15 Februari 2017 15:27, "Cety Carmelo Julita
[email protected] [belajar-excel]" <[email protected]> menulis:
Mohon maaf para suhu, ada pengembangan dalam kasus saya.
Selengakapnya ada dalam lampiran.
Maaf sudah sangat merepotkan.
Makasih atas bantuannya.
#yiv5595174061 #yiv5595174061 -- #yiv5595174061ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5595174061
#yiv5595174061ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5595174061
#yiv5595174061ygrp-mkp #yiv5595174061hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5595174061 #yiv5595174061ygrp-mkp #yiv5595174061ads
{margin-bottom:10px;}#yiv5595174061 #yiv5595174061ygrp-mkp .yiv5595174061ad
{padding:0 0;}#yiv5595174061 #yiv5595174061ygrp-mkp .yiv5595174061ad p
{margin:0;}#yiv5595174061 #yiv5595174061ygrp-mkp .yiv5595174061ad a
{color:#0000ff;text-decoration:none;}#yiv5595174061 #yiv5595174061ygrp-sponsor
#yiv5595174061ygrp-lc {font-family:Arial;}#yiv5595174061
#yiv5595174061ygrp-sponsor #yiv5595174061ygrp-lc #yiv5595174061hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5595174061
#yiv5595174061ygrp-sponsor #yiv5595174061ygrp-lc .yiv5595174061ad
{margin-bottom:10px;padding:0 0;}#yiv5595174061 #yiv5595174061actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5595174061
#yiv5595174061activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5595174061
#yiv5595174061activity span {font-weight:700;}#yiv5595174061
#yiv5595174061activity span:first-child
{text-transform:uppercase;}#yiv5595174061 #yiv5595174061activity span a
{color:#5085b6;text-decoration:none;}#yiv5595174061 #yiv5595174061activity span
span {color:#ff7900;}#yiv5595174061 #yiv5595174061activity span
.yiv5595174061underline {text-decoration:underline;}#yiv5595174061
.yiv5595174061attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5595174061 .yiv5595174061attach div a
{text-decoration:none;}#yiv5595174061 .yiv5595174061attach img
{border:none;padding-right:5px;}#yiv5595174061 .yiv5595174061attach label
{display:block;margin-bottom:5px;}#yiv5595174061 .yiv5595174061attach label a
{text-decoration:none;}#yiv5595174061 blockquote {margin:0 0 0
4px;}#yiv5595174061 .yiv5595174061bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5595174061
.yiv5595174061bold a {text-decoration:none;}#yiv5595174061 dd.yiv5595174061last
p a {font-family:Verdana;font-weight:700;}#yiv5595174061 dd.yiv5595174061last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5595174061
dd.yiv5595174061last p span.yiv5595174061yshortcuts
{margin-right:0;}#yiv5595174061 div.yiv5595174061attach-table div div a
{text-decoration:none;}#yiv5595174061 div.yiv5595174061attach-table
{width:400px;}#yiv5595174061 div.yiv5595174061file-title a, #yiv5595174061
div.yiv5595174061file-title a:active, #yiv5595174061
div.yiv5595174061file-title a:hover, #yiv5595174061 div.yiv5595174061file-title
a:visited {text-decoration:none;}#yiv5595174061 div.yiv5595174061photo-title a,
#yiv5595174061 div.yiv5595174061photo-title a:active, #yiv5595174061
div.yiv5595174061photo-title a:hover, #yiv5595174061
div.yiv5595174061photo-title a:visited {text-decoration:none;}#yiv5595174061
div#yiv5595174061ygrp-mlmsg #yiv5595174061ygrp-msg p a
span.yiv5595174061yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5595174061
.yiv5595174061green {color:#628c2a;}#yiv5595174061 .yiv5595174061MsoNormal
{margin:0 0 0 0;}#yiv5595174061 o {font-size:0;}#yiv5595174061
#yiv5595174061photos div {float:left;width:72px;}#yiv5595174061
#yiv5595174061photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5595174061
#yiv5595174061photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5595174061
#yiv5595174061reco-category {font-size:77%;}#yiv5595174061
#yiv5595174061reco-desc {font-size:77%;}#yiv5595174061 .yiv5595174061replbq
{margin:4px;}#yiv5595174061 #yiv5595174061ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5595174061 #yiv5595174061ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5595174061
#yiv5595174061ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5595174061
#yiv5595174061ygrp-mlmsg select, #yiv5595174061 input, #yiv5595174061 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5595174061
#yiv5595174061ygrp-mlmsg pre, #yiv5595174061 code {font:115%
monospace;}#yiv5595174061 #yiv5595174061ygrp-mlmsg *
{line-height:1.22em;}#yiv5595174061 #yiv5595174061ygrp-mlmsg #yiv5595174061logo
{padding-bottom:10px;}#yiv5595174061 #yiv5595174061ygrp-msg p a
{font-family:Verdana;}#yiv5595174061 #yiv5595174061ygrp-msg
p#yiv5595174061attach-count span {color:#1E66AE;font-weight:700;}#yiv5595174061
#yiv5595174061ygrp-reco #yiv5595174061reco-head
{color:#ff7900;font-weight:700;}#yiv5595174061 #yiv5595174061ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5595174061 #yiv5595174061ygrp-sponsor
#yiv5595174061ov li a {font-size:130%;text-decoration:none;}#yiv5595174061
#yiv5595174061ygrp-sponsor #yiv5595174061ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5595174061
#yiv5595174061ygrp-sponsor #yiv5595174061ov ul {margin:0;padding:0 0 0
8px;}#yiv5595174061 #yiv5595174061ygrp-text
{font-family:Georgia;}#yiv5595174061 #yiv5595174061ygrp-text p {margin:0 0 1em
0;}#yiv5595174061 #yiv5595174061ygrp-text tt {font-size:120%;}#yiv5595174061
#yiv5595174061ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5595174061
