File nya sudah saya lampirkan pak Hendrik. Mohon bimbingannya. Best Regards,FERY
On Friday, July 21, 2017, 5:33:20 PM GMT+7, hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote: Hai Febry,Coba dilampirkan dummy file Excelnya dan apa yang sdh dilakukan. Salam,HK On Friday, July 21, 2017, 5:17:38 PM GMT+7, Febry Ferian [email protected] [belajar-excel] <[email protected]> wrote: Assalamualaikum, salam sejahtera dan selamat siang para Master dan member milis, Saya punya kendala dalam pengambilan data dengan menggunakan multiple kriteria di excel. Saya sudah mencoba browsing tentang penggunaan SUMIFS, SUMPRODUCT, maupun INDEX dan LOOKUP serta sejenisnya. Namun saya masih belum menemukan solusi seperti yg saya butuhkan. Kesulitan yg ingin saya selesaikan ada di dalam file yg saya lampirkan berikut penjelasannya. Mohin bantuan master dan member sekalian. Terima kasih dan sukses selalu. Sent from Yahoo Mail on Android #yiv3947373987 #yiv3947373987 -- #yiv3947373987ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3947373987 #yiv3947373987ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3947373987 #yiv3947373987ygrp-mkp #yiv3947373987hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3947373987 #yiv3947373987ygrp-mkp #yiv3947373987ads {margin-bottom:10px;}#yiv3947373987 #yiv3947373987ygrp-mkp .yiv3947373987ad {padding:0 0;}#yiv3947373987 #yiv3947373987ygrp-mkp .yiv3947373987ad p {margin:0;}#yiv3947373987 #yiv3947373987ygrp-mkp .yiv3947373987ad a {color:#0000ff;text-decoration:none;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ygrp-lc {font-family:Arial;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ygrp-lc #yiv3947373987hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ygrp-lc .yiv3947373987ad {margin-bottom:10px;padding:0 0;}#yiv3947373987 #yiv3947373987actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3947373987 #yiv3947373987activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3947373987 #yiv3947373987activity span {font-weight:700;}#yiv3947373987 #yiv3947373987activity span:first-child {text-transform:uppercase;}#yiv3947373987 #yiv3947373987activity span a {color:#5085b6;text-decoration:none;}#yiv3947373987 #yiv3947373987activity span span {color:#ff7900;}#yiv3947373987 #yiv3947373987activity span .yiv3947373987underline {text-decoration:underline;}#yiv3947373987 .yiv3947373987attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3947373987 .yiv3947373987attach div a {text-decoration:none;}#yiv3947373987 .yiv3947373987attach img {border:none;padding-right:5px;}#yiv3947373987 .yiv3947373987attach label {display:block;margin-bottom:5px;}#yiv3947373987 .yiv3947373987attach label a {text-decoration:none;}#yiv3947373987 blockquote {margin:0 0 0 4px;}#yiv3947373987 .yiv3947373987bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3947373987 .yiv3947373987bold a {text-decoration:none;}#yiv3947373987 dd.yiv3947373987last p a {font-family:Verdana;font-weight:700;}#yiv3947373987 dd.yiv3947373987last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3947373987 dd.yiv3947373987last p span.yiv3947373987yshortcuts {margin-right:0;}#yiv3947373987 div.yiv3947373987attach-table div div a {text-decoration:none;}#yiv3947373987 div.yiv3947373987attach-table {width:400px;}#yiv3947373987 div.yiv3947373987file-title a, #yiv3947373987 div.yiv3947373987file-title a:active, #yiv3947373987 div.yiv3947373987file-title a:hover, #yiv3947373987 div.yiv3947373987file-title a:visited {text-decoration:none;}#yiv3947373987 div.yiv3947373987photo-title a, #yiv3947373987 div.yiv3947373987photo-title a:active, #yiv3947373987 div.yiv3947373987photo-title a:hover, #yiv3947373987 div.yiv3947373987photo-title a:visited {text-decoration:none;}#yiv3947373987 div#yiv3947373987ygrp-mlmsg #yiv3947373987ygrp-msg p a span.yiv3947373987yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3947373987 .yiv3947373987green {color:#628c2a;}#yiv3947373987 .yiv3947373987MsoNormal {margin:0 0 0 0;}#yiv3947373987 o {font-size:0;}#yiv3947373987 #yiv3947373987photos div {float:left;width:72px;}#yiv3947373987 #yiv3947373987photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3947373987 #yiv3947373987photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3947373987 #yiv3947373987reco-category {font-size:77%;}#yiv3947373987 #yiv3947373987reco-desc {font-size:77%;}#yiv3947373987 .yiv3947373987replbq {margin:4px;}#yiv3947373987 #yiv3947373987ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3947373987 #yiv3947373987ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3947373987 #yiv3947373987ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3947373987 #yiv3947373987ygrp-mlmsg select, #yiv3947373987 input, #yiv3947373987 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3947373987 #yiv3947373987ygrp-mlmsg pre, #yiv3947373987 code {font:115% monospace;}#yiv3947373987 #yiv3947373987ygrp-mlmsg * {line-height:1.22em;}#yiv3947373987 #yiv3947373987ygrp-mlmsg #yiv3947373987logo {padding-bottom:10px;}#yiv3947373987 #yiv3947373987ygrp-msg p a {font-family:Verdana;}#yiv3947373987 #yiv3947373987ygrp-msg p#yiv3947373987attach-count span {color:#1E66AE;font-weight:700;}#yiv3947373987 #yiv3947373987ygrp-reco #yiv3947373987reco-head {color:#ff7900;font-weight:700;}#yiv3947373987 #yiv3947373987ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ov li a {font-size:130%;text-decoration:none;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3947373987 #yiv3947373987ygrp-sponsor #yiv3947373987ov ul {margin:0;padding:0 0 0 8px;}#yiv3947373987 #yiv3947373987ygrp-text {font-family:Georgia;}#yiv3947373987 #yiv3947373987ygrp-text p {margin:0 0 1em 0;}#yiv3947373987 #yiv3947373987ygrp-text tt {font-size:120%;}#yiv3947373987 #yiv3947373987ygrp-vital ul li:last-child {border-right:none !important;}#yiv3947373987
contoh soal.xlsx
Description: MS-Excel 2007 spreadsheet
