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' mr.nm...@gmail.com
[belajar-excel]" 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 tonybex...@yahoo.co.id [belajar-excel]
:
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
#yiv0045969502 #yiv0045969502 -- #yiv0045969502ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0045969502
#yiv0045969502ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0045969502
#yiv0045969502ygrp-mkp #yiv0045969502hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0045969502 #yiv0045969502ygrp-mkp #yiv0045969502ads
{margin-bottom:10px;}#yiv0045969502 #yiv0045969502ygrp-mkp .yiv0045969502ad
{padding:0 0;}#yiv0045969502 #yiv0045969502ygrp-mkp .yiv0045969502ad p
{margin:0;}#yiv0045969502 #yiv0045969502ygrp-mkp .yiv0045969502ad a
{color:#ff;text-decoration:none;}#yiv0045969502 #yiv0045969502ygrp-sponsor
#yiv0045969502ygrp-lc {font-family:Arial;}#yiv0045969502
#yiv0045969502ygrp-sponsor #yiv0045969502ygrp-lc #yiv0045969502hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0045969502
#yiv0045969502ygrp-sponsor #yiv0045969502ygrp-lc .yiv0045969502ad
{margin-bottom:10px;padding:0 0;}#yiv0045969502 #yiv0045969502actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0045969502
#yiv0045969502activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0045969502
#yiv0045969502activity span {font-weight:700;}#yiv0045969502
#yiv0045969502activity span:first-child
{text-transform:uppercase;}#yiv0045969502 #yiv0045969502activity span a
{color:#5085b6;text-decoration:none;}#yiv0045969502 #yiv0045969502activity span
span {color:#ff7900;}#yiv0045969502 #yiv0045969502activity span
.yiv0045969502underline {text-decoration:underline;}#yiv0045969502
.yiv0045969502attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0045969502 .yiv0045969502attach div a
{text-decoration:none;}#yiv0045969502 .yiv0045969502attach img
{border:none;padding-right:5px;}#yiv0045969502 .yiv0045969502attach label
{display:block;margin-bottom:5px;}#yiv0045969502 .yiv0045969502attach label a
{text-decoration:none;}#yiv0045969502 blockquote {margin:0 0 0
4px;}#yiv0045969502 .yiv0045969502bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0045969502
.yiv0045969502bold a {text-decoration:none;}#yiv0045969502 dd.yiv0045969502last
p a {font-family:Verdana;font-weight:700;}#yiv0045969502 dd.yiv0045969502last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0045969502
dd.yiv0045969502last p span.yiv0045969502yshortcuts
{margin-right:0;}#yiv0045969502 div.yiv0045969502attach-table div div a
{text-decoration:none;}#yiv0045969502 div.yiv0045969502attach-table
{width:400px;}#yiv0045969502 div.yiv0045969502file-title a, #yiv0045969502
div.yiv0045969502file-title a:active, #yiv0045969502
div.yiv0045969502file-title a:hover, #yiv0045969502 div.yiv0045969502file-title
a:visited {text-decoration:none;}#yiv0045969502 div.yiv0045969502photo-title a,
#yiv0045969502 div.yiv0045969502photo-title a:active, #yiv0045969502
div.yiv0045969502photo-title a:hover, #yiv0045969502
div.yiv0045969502photo-title a:visited {text-decoration:none;}#yiv0045969502
div#yiv0045969502ygrp-mlmsg #yiv0045969502ygrp-msg p a
span.yiv0045969502yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0045969502
.yiv0045969502green {color:#628c2a;}#yiv0045969502 .yiv0045969502MsoNormal
{margin:0 0 0 0;}#yiv0045969502 o {font-size:0;}#yiv0045969502
#yiv0045969502photos div {float:left;width:72px;}#yiv0045969502
#yiv0045969502photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv0045969502
#yiv0045969502photos div label