Dear Pak Uharyanto,
Salam
Setelah saya pakai hasilnya masih 0 Pak, mohon pencerahan.
Dear Mr. Kid,
saya mencoba menggunakan rumus tersebut tapi masih bingung dalam penentuan
criterianya (nilai tidak keluar). saya coba cek di google gak ada literatur
tentang AVERAGEIF yang ada cuman average atau if saja. mohon penjelasannya.
Terimakasih,
Krisan,
Pada Selasa, 24 Maret 2015 13:24, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
di xl2007 ke atas ada fungsi Average, AverageIF, dan AverageIFs loh...
;)
2015-03-24 14:29 GMT+11:00 uharyanto uharya...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
Coba pake array formula
{=AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))}
Terima kasih.
On 24/03/2015 9:11 AM, Krisan Flower krisan_flo...@rocketmail.com
[belajar-excel] wrote:
Dear Para Master,
Salam,
Saya kesulitan dalam mengambil nilai average dari kriteria di sebuah sheet,
berikut saya lampirkan contoh kasusnya, Mungkin ada banyak dari rekan2 yang
punya persoalan yang sama dengan saya. Makasi sebelumnya.
Krisan.
#yiv3121736440 #yiv3121736440 -- #yiv3121736440ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3121736440
#yiv3121736440ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3121736440
#yiv3121736440ygrp-mkp #yiv3121736440hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3121736440 #yiv3121736440ygrp-mkp #yiv3121736440ads
{margin-bottom:10px;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad
{padding:0 0;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad p
{margin:0;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad a
{color:#0000ff;text-decoration:none;}#yiv3121736440 #yiv3121736440ygrp-sponsor
#yiv3121736440ygrp-lc {font-family:Arial;}#yiv3121736440
#yiv3121736440ygrp-sponsor #yiv3121736440ygrp-lc #yiv3121736440hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3121736440
#yiv3121736440ygrp-sponsor #yiv3121736440ygrp-lc .yiv3121736440ad
{margin-bottom:10px;padding:0 0;}#yiv3121736440 #yiv3121736440actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3121736440
#yiv3121736440activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3121736440
#yiv3121736440activity span {font-weight:700;}#yiv3121736440
#yiv3121736440activity span:first-child
{text-transform:uppercase;}#yiv3121736440 #yiv3121736440activity span a
{color:#5085b6;text-decoration:none;}#yiv3121736440 #yiv3121736440activity span
span {color:#ff7900;}#yiv3121736440 #yiv3121736440activity span
.yiv3121736440underline {text-decoration:underline;}#yiv3121736440
.yiv3121736440attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3121736440 .yiv3121736440attach div a
{text-decoration:none;}#yiv3121736440 .yiv3121736440attach img
{border:none;padding-right:5px;}#yiv3121736440 .yiv3121736440attach label
{display:block;margin-bottom:5px;}#yiv3121736440 .yiv3121736440attach label a
{text-decoration:none;}#yiv3121736440 blockquote {margin:0 0 0
4px;}#yiv3121736440 .yiv3121736440bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3121736440
.yiv3121736440bold a {text-decoration:none;}#yiv3121736440 dd.yiv3121736440last
p a {font-family:Verdana;font-weight:700;}#yiv3121736440 dd.yiv3121736440last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3121736440
dd.yiv3121736440last p span.yiv3121736440yshortcuts
{margin-right:0;}#yiv3121736440 div.yiv3121736440attach-table div div a
{text-decoration:none;}#yiv3121736440 div.yiv3121736440attach-table
{width:400px;}#yiv3121736440 div.yiv3121736440file-title a, #yiv3121736440
div.yiv3121736440file-title a:active, #yiv3121736440
div.yiv3121736440file-title a:hover, #yiv3121736440 div.yiv3121736440file-title
a:visited {text-decoration:none;}#yiv3121736440 div.yiv3121736440photo-title a,
#yiv3121736440 div.yiv3121736440photo-title a:active, #yiv3121736440
div.yiv3121736440photo-title a:hover, #yiv3121736440
div.yiv3121736440photo-title a:visited {text-decoration:none;}#yiv3121736440
div#yiv3121736440ygrp-mlmsg #yiv3121736440ygrp-msg p a
span.yiv3121736440yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3121736440
.yiv3121736440green {color:#628c2a;}#yiv3121736440 .yiv3121736440MsoNormal
{margin:0 0 0 0;}#yiv3121736440 o {font-size:0;}#yiv3121736440
#yiv3121736440photos div {float:left;width:72px;}#yiv3121736440
#yiv3121736440photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3121736440
#yiv3121736440photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3121736440
#yiv3121736440reco-category {font-size:77%;}#yiv3121736440
#yiv3121736440reco-desc {font-size:77%;}#yiv3121736440 .yiv3121736440replbq
{margin:4px;}#yiv3121736440 #yiv3121736440ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3121736440 #yiv3121736440ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3121736440
#yiv3121736440ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3121736440
#yiv3121736440ygrp-mlmsg select, #yiv3121736440 input, #yiv3121736440 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3121736440
#yiv3121736440ygrp-mlmsg pre, #yiv3121736440 code {font:115%
monospace;}#yiv3121736440 #yiv3121736440ygrp-mlmsg *
{line-height:1.22em;}#yiv3121736440 #yiv3121736440ygrp-mlmsg #yiv3121736440logo
{padding-bottom:10px;}#yiv3121736440 #yiv3121736440ygrp-msg p a
{font-family:Verdana;}#yiv3121736440 #yiv3121736440ygrp-msg
p#yiv3121736440attach-count span {color:#1E66AE;font-weight:700;}#yiv3121736440
#yiv3121736440ygrp-reco #yiv3121736440reco-head
{color:#ff7900;font-weight:700;}#yiv3121736440 #yiv3121736440ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3121736440 #yiv3121736440ygrp-sponsor
#yiv3121736440ov li a {font-size:130%;text-decoration:none;}#yiv3121736440
#yiv3121736440ygrp-sponsor #yiv3121736440ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3121736440
#yiv3121736440ygrp-sponsor #yiv3121736440ov ul {margin:0;padding:0 0 0
8px;}#yiv3121736440 #yiv3121736440ygrp-text
{font-family:Georgia;}#yiv3121736440 #yiv3121736440ygrp-text p {margin:0 0 1em
0;}#yiv3121736440 #yiv3121736440ygrp-text tt {font-size:120%;}#yiv3121736440
#yiv3121736440ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3121736440
