Dear Pakar yang Budiman..
Terimakasih Mr.Kids dan semua temans yang bergabung di milis ini..File nya
sudah benar ...horeeeeee...
Salam,Tony B
Pada Selasa, 29 September 2015 16:02, "Tony Bexcel [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pakar yang budiman,
Mau konfirmasi dong Mr.Kid yang baik hati.. :)Saya bingung dengan File yang
Mr.Kid kirim, seperti nya bukan dari File pertanyaan saya..jadi saya bingung
memahami formula nya. :(Terlampir File yang saya kirimkan sebelum nya ya
Mr.Kid..Terimakasih sebelum dan sesudahnya..
Salam hangat,Tony B
Pada Selasa, 29 September 2015 10:05, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Tony,
Fungsi SumIFs bisa digunakan untuk sum berdasar lebih dari 1 kriteria. Dengan
fungsi SumIFs ini, maka tidak diperlukan pembentukan composite key berupa
gabungan item di sheet sumber datanya.
Fungsi SumIF(s),CountIF(s), dsb bisa memanfaatkan wildcard character seperti *
atau ?
Penyusunan suatu kondisi (dengan fungsi IF) digunakan untuk menyusun kriteria
yang bisa memanfaatkan wildcard character tersebut.
File terlampir.
Wassalam,
Kid
2015-09-28 17:19 GMT+07:00 Tony Bexcel [email protected] [belajar-excel]
<[email protected]>:
Dear Pakar yang Budiman dan Temans Excel semua,
Salam sejahtera..kali ini saya mohon bantuan nya apakah untuk mencari total
pada filter validasi bisa dilakukan?Agar tidak membingungkan penyampaian
,berikut saya lampirkan contoh nya temans..Terimakasih ats segala waktu dan
ilmu nya ya temansss..
Salam,Tony B
#yiv0348943935 #yiv0348943935 -- #yiv0348943935ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0348943935
#yiv0348943935ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0348943935
#yiv0348943935ygrp-mkp #yiv0348943935hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0348943935 #yiv0348943935ygrp-mkp #yiv0348943935ads
{margin-bottom:10px;}#yiv0348943935 #yiv0348943935ygrp-mkp .yiv0348943935ad
{padding:0 0;}#yiv0348943935 #yiv0348943935ygrp-mkp .yiv0348943935ad p
{margin:0;}#yiv0348943935 #yiv0348943935ygrp-mkp .yiv0348943935ad a
{color:#0000ff;text-decoration:none;}#yiv0348943935 #yiv0348943935ygrp-sponsor
#yiv0348943935ygrp-lc {font-family:Arial;}#yiv0348943935
#yiv0348943935ygrp-sponsor #yiv0348943935ygrp-lc #yiv0348943935hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0348943935
#yiv0348943935ygrp-sponsor #yiv0348943935ygrp-lc .yiv0348943935ad
{margin-bottom:10px;padding:0 0;}#yiv0348943935 #yiv0348943935actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0348943935
#yiv0348943935activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0348943935
#yiv0348943935activity span {font-weight:700;}#yiv0348943935
#yiv0348943935activity span:first-child
{text-transform:uppercase;}#yiv0348943935 #yiv0348943935activity span a
{color:#5085b6;text-decoration:none;}#yiv0348943935 #yiv0348943935activity span
span {color:#ff7900;}#yiv0348943935 #yiv0348943935activity span
.yiv0348943935underline {text-decoration:underline;}#yiv0348943935
.yiv0348943935attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0348943935 .yiv0348943935attach div a
{text-decoration:none;}#yiv0348943935 .yiv0348943935attach img
{border:none;padding-right:5px;}#yiv0348943935 .yiv0348943935attach label
{display:block;margin-bottom:5px;}#yiv0348943935 .yiv0348943935attach label a
{text-decoration:none;}#yiv0348943935 blockquote {margin:0 0 0
4px;}#yiv0348943935 .yiv0348943935bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0348943935
.yiv0348943935bold a {text-decoration:none;}#yiv0348943935 dd.yiv0348943935last
p a {font-family:Verdana;font-weight:700;}#yiv0348943935 dd.yiv0348943935last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0348943935
dd.yiv0348943935last p span.yiv0348943935yshortcuts
{margin-right:0;}#yiv0348943935 div.yiv0348943935attach-table div div a
{text-decoration:none;}#yiv0348943935 div.yiv0348943935attach-table
{width:400px;}#yiv0348943935 div.yiv0348943935file-title a, #yiv0348943935
div.yiv0348943935file-title a:active, #yiv0348943935
div.yiv0348943935file-title a:hover, #yiv0348943935 div.yiv0348943935file-title
a:visited {text-decoration:none;}#yiv0348943935 div.yiv0348943935photo-title a,
#yiv0348943935 div.yiv0348943935photo-title a:active, #yiv0348943935
div.yiv0348943935photo-title a:hover, #yiv0348943935
div.yiv0348943935photo-title a:visited {text-decoration:none;}#yiv0348943935
div#yiv0348943935ygrp-mlmsg #yiv0348943935ygrp-msg p a
span.yiv0348943935yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0348943935
.yiv0348943935green {color:#628c2a;}#yiv0348943935 .yiv0348943935MsoNormal
{margin:0 0 0 0;}#yiv0348943935 o {font-size:0;}#yiv0348943935
#yiv0348943935photos div {float:left;width:72px;}#yiv0348943935
#yiv0348943935photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0348943935
#yiv0348943935photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0348943935
#yiv0348943935reco-category {font-size:77%;}#yiv0348943935
#yiv0348943935reco-desc {font-size:77%;}#yiv0348943935 .yiv0348943935replbq
{margin:4px;}#yiv0348943935 #yiv0348943935ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0348943935 #yiv0348943935ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0348943935
#yiv0348943935ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0348943935
#yiv0348943935ygrp-mlmsg select, #yiv0348943935 input, #yiv0348943935 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0348943935
#yiv0348943935ygrp-mlmsg pre, #yiv0348943935 code {font:115%
monospace;}#yiv0348943935 #yiv0348943935ygrp-mlmsg *
{line-height:1.22em;}#yiv0348943935 #yiv0348943935ygrp-mlmsg #yiv0348943935logo
{padding-bottom:10px;}#yiv0348943935 #yiv0348943935ygrp-msg p a
{font-family:Verdana;}#yiv0348943935 #yiv0348943935ygrp-msg
p#yiv0348943935attach-count span {color:#1E66AE;font-weight:700;}#yiv0348943935
#yiv0348943935ygrp-reco #yiv0348943935reco-head
{color:#ff7900;font-weight:700;}#yiv0348943935 #yiv0348943935ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0348943935 #yiv0348943935ygrp-sponsor
#yiv0348943935ov li a {font-size:130%;text-decoration:none;}#yiv0348943935
#yiv0348943935ygrp-sponsor #yiv0348943935ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0348943935
#yiv0348943935ygrp-sponsor #yiv0348943935ov ul {margin:0;padding:0 0 0
8px;}#yiv0348943935 #yiv0348943935ygrp-text
{font-family:Georgia;}#yiv0348943935 #yiv0348943935ygrp-text p {margin:0 0 1em
0;}#yiv0348943935 #yiv0348943935ygrp-text tt {font-size:120%;}#yiv0348943935
#yiv0348943935ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0348943935
