klo sepengetahuan saya sih average cuma bekerja hanya pada cell yang terisi,
sementara yang tidak ada isinya (blank) atau berisi namun bukan numerik, maka
tidak berpengaruh pada perhitungan average, kecuali bernilai nol. br,
odong nando
Dari: "Nicodemus Rusdiyanto [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Kamis, 18 Agustus 2016 13:36
Judul: [belajar-excel] 7 days average [1 Attachment]
dear Mastah,
Mohon pencerahan untuk mencari data average 7 hari kebelakang, dengan
kriteria;1. apabila sudah berbeda bulan, maka average menggunakan hari baru
(maksudnya adalah mulai lagi dari tanggal 1 dan seterusnya)formula yang saya
punya; menggunakan AVERAGEIF, hanya mendetect 7 hari kebelakang tanpa detect
bulan. (file terlampir)2. Data terlampir, hanya menampilkan hari yang ada
transaksi saja, padahal saya juga memerlukan average untuk hari yang tidak
tampil, misal Sabtu/Minggu atau hari libur, karena pasti berpengaruh pada
average kan?
--
Thanks in advance,Nico #yiv9780679812 #yiv9780679812 -- #yiv9780679812ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv9780679812 #yiv9780679812ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9780679812 #yiv9780679812ygrp-mkp #yiv9780679812hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9780679812 #yiv9780679812ygrp-mkp #yiv9780679812ads
{margin-bottom:10px;}#yiv9780679812 #yiv9780679812ygrp-mkp .yiv9780679812ad
{padding:0 0;}#yiv9780679812 #yiv9780679812ygrp-mkp .yiv9780679812ad p
{margin:0;}#yiv9780679812 #yiv9780679812ygrp-mkp .yiv9780679812ad a
{color:#0000ff;text-decoration:none;}#yiv9780679812 #yiv9780679812ygrp-sponsor
#yiv9780679812ygrp-lc {font-family:Arial;}#yiv9780679812
#yiv9780679812ygrp-sponsor #yiv9780679812ygrp-lc #yiv9780679812hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9780679812
#yiv9780679812ygrp-sponsor #yiv9780679812ygrp-lc .yiv9780679812ad
{margin-bottom:10px;padding:0 0;}#yiv9780679812 #yiv9780679812actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9780679812
#yiv9780679812activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9780679812
#yiv9780679812activity span {font-weight:700;}#yiv9780679812
#yiv9780679812activity span:first-child
{text-transform:uppercase;}#yiv9780679812 #yiv9780679812activity span a
{color:#5085b6;text-decoration:none;}#yiv9780679812 #yiv9780679812activity span
span {color:#ff7900;}#yiv9780679812 #yiv9780679812activity span
.yiv9780679812underline {text-decoration:underline;}#yiv9780679812
.yiv9780679812attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9780679812 .yiv9780679812attach div a
{text-decoration:none;}#yiv9780679812 .yiv9780679812attach img
{border:none;padding-right:5px;}#yiv9780679812 .yiv9780679812attach label
{display:block;margin-bottom:5px;}#yiv9780679812 .yiv9780679812attach label a
{text-decoration:none;}#yiv9780679812 blockquote {margin:0 0 0
4px;}#yiv9780679812 .yiv9780679812bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9780679812
.yiv9780679812bold a {text-decoration:none;}#yiv9780679812 dd.yiv9780679812last
p a {font-family:Verdana;font-weight:700;}#yiv9780679812 dd.yiv9780679812last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9780679812
dd.yiv9780679812last p span.yiv9780679812yshortcuts
{margin-right:0;}#yiv9780679812 div.yiv9780679812attach-table div div a
{text-decoration:none;}#yiv9780679812 div.yiv9780679812attach-table
{width:400px;}#yiv9780679812 div.yiv9780679812file-title a, #yiv9780679812
div.yiv9780679812file-title a:active, #yiv9780679812
div.yiv9780679812file-title a:hover, #yiv9780679812 div.yiv9780679812file-title
a:visited {text-decoration:none;}#yiv9780679812 div.yiv9780679812photo-title a,
#yiv9780679812 div.yiv9780679812photo-title a:active, #yiv9780679812
div.yiv9780679812photo-title a:hover, #yiv9780679812
div.yiv9780679812photo-title a:visited {text-decoration:none;}#yiv9780679812
div#yiv9780679812ygrp-mlmsg #yiv9780679812ygrp-msg p a
span.yiv9780679812yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9780679812
.yiv9780679812green {color:#628c2a;}#yiv9780679812 .yiv9780679812MsoNormal
{margin:0 0 0 0;}#yiv9780679812 o {font-size:0;}#yiv9780679812
#yiv9780679812photos div {float:left;width:72px;}#yiv9780679812
#yiv9780679812photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9780679812
#yiv9780679812photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9780679812
#yiv9780679812reco-category {font-size:77%;}#yiv9780679812
#yiv9780679812reco-desc {font-size:77%;}#yiv9780679812 .yiv9780679812replbq
{margin:4px;}#yiv9780679812 #yiv9780679812ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9780679812 #yiv9780679812ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9780679812
#yiv9780679812ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9780679812
#yiv9780679812ygrp-mlmsg select, #yiv9780679812 input, #yiv9780679812 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9780679812
#yiv9780679812ygrp-mlmsg pre, #yiv9780679812 code {font:115%
monospace;}#yiv9780679812 #yiv9780679812ygrp-mlmsg *
{line-height:1.22em;}#yiv9780679812 #yiv9780679812ygrp-mlmsg #yiv9780679812logo
{padding-bottom:10px;}#yiv9780679812 #yiv9780679812ygrp-msg p a
{font-family:Verdana;}#yiv9780679812 #yiv9780679812ygrp-msg
p#yiv9780679812attach-count span {color:#1E66AE;font-weight:700;}#yiv9780679812
#yiv9780679812ygrp-reco #yiv9780679812reco-head
{color:#ff7900;font-weight:700;}#yiv9780679812 #yiv9780679812ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9780679812 #yiv9780679812ygrp-sponsor
#yiv9780679812ov li a {font-size:130%;text-decoration:none;}#yiv9780679812
#yiv9780679812ygrp-sponsor #yiv9780679812ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9780679812
#yiv9780679812ygrp-sponsor #yiv9780679812ov ul {margin:0;padding:0 0 0
8px;}#yiv9780679812 #yiv9780679812ygrp-text
{font-family:Georgia;}#yiv9780679812 #yiv9780679812ygrp-text p {margin:0 0 1em
0;}#yiv9780679812 #yiv9780679812ygrp-text tt {font-size:120%;}#yiv9780679812
#yiv9780679812ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9780679812
