Dear Mr. Kid
terimakasih banyak, sesuai dengan yang saya maksud.akan saya pelajari lagi,
Terimakasih.
Pada Kamis, 21 Januari 2016 23:46, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
Hai Nanank,
Jika akan mengambil total suatu data berdasar :
a. suatu kriteria (umumnya 2 kriteria atau lebih) adalah dengan SumIFs walau
bisa dengan array formula Sum atau SumProduct
b. 1 (satu) kriteria, umumnya dengan SumIF walau bisa dengan SumIFs atau array
formula Sum atau SumProduct.
c. 0 (nol) kriteria, umumnya dengan Sum walaupun bisa dengan SumIF atau SumIFs
atau SumProduct
Untuk menghitung cacah item (seperti menghitung jumlah record), maka hal
tersebut di atas tetap berlaku, tetapi bunyi Sum diganti dengan Count kecuali
pada SumProduct.
Penjelasan tentang fungsi-fungsi yang disebut di atas bisa Anda dapatkan di
dalam Excel Help.
File terlampir memanfaatkan fungsi SumIFs.
Wassalamu'alaikum wr wb
Kid
2016-01-21 17:14 GMT+07:00 Flow Nanank flow.nan...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
Assalamu 'alaikum wr wb
Saya newbie mau tanya Rumus terlampir, biasanya sy menggunakan Vlookup dg 1
kondisi, kali ini dengan 2 kondisi perbandingan, mohon solusinya.
please see attach ,
Terimakasih.
Br,
Nanang
#yiv9901446723 #yiv9901446723 -- #yiv9901446723ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9901446723
#yiv9901446723ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9901446723
#yiv9901446723ygrp-mkp #yiv9901446723hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9901446723 #yiv9901446723ygrp-mkp #yiv9901446723ads
{margin-bottom:10px;}#yiv9901446723 #yiv9901446723ygrp-mkp .yiv9901446723ad
{padding:0 0;}#yiv9901446723 #yiv9901446723ygrp-mkp .yiv9901446723ad p
{margin:0;}#yiv9901446723 #yiv9901446723ygrp-mkp .yiv9901446723ad a
{color:#0000ff;text-decoration:none;}#yiv9901446723 #yiv9901446723ygrp-sponsor
#yiv9901446723ygrp-lc {font-family:Arial;}#yiv9901446723
#yiv9901446723ygrp-sponsor #yiv9901446723ygrp-lc #yiv9901446723hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9901446723
#yiv9901446723ygrp-sponsor #yiv9901446723ygrp-lc .yiv9901446723ad
{margin-bottom:10px;padding:0 0;}#yiv9901446723 #yiv9901446723actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9901446723
#yiv9901446723activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9901446723
#yiv9901446723activity span {font-weight:700;}#yiv9901446723
#yiv9901446723activity span:first-child
{text-transform:uppercase;}#yiv9901446723 #yiv9901446723activity span a
{color:#5085b6;text-decoration:none;}#yiv9901446723 #yiv9901446723activity span
span {color:#ff7900;}#yiv9901446723 #yiv9901446723activity span
.yiv9901446723underline {text-decoration:underline;}#yiv9901446723
.yiv9901446723attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9901446723 .yiv9901446723attach div a
{text-decoration:none;}#yiv9901446723 .yiv9901446723attach img
{border:none;padding-right:5px;}#yiv9901446723 .yiv9901446723attach label
{display:block;margin-bottom:5px;}#yiv9901446723 .yiv9901446723attach label a
{text-decoration:none;}#yiv9901446723 blockquote {margin:0 0 0
4px;}#yiv9901446723 .yiv9901446723bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9901446723
.yiv9901446723bold a {text-decoration:none;}#yiv9901446723 dd.yiv9901446723last
p a {font-family:Verdana;font-weight:700;}#yiv9901446723 dd.yiv9901446723last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9901446723
dd.yiv9901446723last p span.yiv9901446723yshortcuts
{margin-right:0;}#yiv9901446723 div.yiv9901446723attach-table div div a
{text-decoration:none;}#yiv9901446723 div.yiv9901446723attach-table
{width:400px;}#yiv9901446723 div.yiv9901446723file-title a, #yiv9901446723
div.yiv9901446723file-title a:active, #yiv9901446723
div.yiv9901446723file-title a:hover, #yiv9901446723 div.yiv9901446723file-title
a:visited {text-decoration:none;}#yiv9901446723 div.yiv9901446723photo-title a,
#yiv9901446723 div.yiv9901446723photo-title a:active, #yiv9901446723
div.yiv9901446723photo-title a:hover, #yiv9901446723
div.yiv9901446723photo-title a:visited {text-decoration:none;}#yiv9901446723
div#yiv9901446723ygrp-mlmsg #yiv9901446723ygrp-msg p a
span.yiv9901446723yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9901446723
.yiv9901446723green {color:#628c2a;}#yiv9901446723 .yiv9901446723MsoNormal
{margin:0 0 0 0;}#yiv9901446723 o {font-size:0;}#yiv9901446723
#yiv9901446723photos div {float:left;width:72px;}#yiv9901446723
#yiv9901446723photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9901446723
#yiv9901446723photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9901446723
#yiv9901446723reco-category {font-size:77%;}#yiv9901446723
#yiv9901446723reco-desc {font-size:77%;}#yiv9901446723 .yiv9901446723replbq
{margin:4px;}#yiv9901446723 #yiv9901446723ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9901446723 #yiv9901446723ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9901446723
#yiv9901446723ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9901446723
#yiv9901446723ygrp-mlmsg select, #yiv9901446723 input, #yiv9901446723 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9901446723
#yiv9901446723ygrp-mlmsg pre, #yiv9901446723 code {font:115%
monospace;}#yiv9901446723 #yiv9901446723ygrp-mlmsg *
{line-height:1.22em;}#yiv9901446723 #yiv9901446723ygrp-mlmsg #yiv9901446723logo
{padding-bottom:10px;}#yiv9901446723 #yiv9901446723ygrp-msg p a
{font-family:Verdana;}#yiv9901446723 #yiv9901446723ygrp-msg
p#yiv9901446723attach-count span {color:#1E66AE;font-weight:700;}#yiv9901446723
#yiv9901446723ygrp-reco #yiv9901446723reco-head
{color:#ff7900;font-weight:700;}#yiv9901446723 #yiv9901446723ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9901446723 #yiv9901446723ygrp-sponsor
#yiv9901446723ov li a {font-size:130%;text-decoration:none;}#yiv9901446723
#yiv9901446723ygrp-sponsor #yiv9901446723ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9901446723
#yiv9901446723ygrp-sponsor #yiv9901446723ov ul {margin:0;padding:0 0 0
8px;}#yiv9901446723 #yiv9901446723ygrp-text
{font-family:Georgia;}#yiv9901446723 #yiv9901446723ygrp-text p {margin:0 0 1em
0;}#yiv9901446723 #yiv9901446723ygrp-text tt {font-size:120%;}#yiv9901446723
#yiv9901446723ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9901446723
